How to map 1 value into the same row of another column in ETL

Reply
Visitor

How to map 1 value into the same row of another column in ETL

Please see attachment. I need to map a value from one column to another. 

 

Context: Marketing's Department ID needs to be the same as its Organization ID. I've tried Value Mapper but it seems like that will only allow me to make a brand new column. I don't want a brand new column.

 

Please help! Which ETL function should I use?


Accepted Solutions
Black Belt

Re: How to map 1 value into the same row of another column in ETL

Is the Marketing Department the only department that is missing an Organization ID?

 

if all the other rows apart from marketing have a value in them, you could just use a replace text to replace any null or blank values with 4410.

 

otherwise you would need to filter just the marketing values first and then perform the replace text on the organization I’d field. 


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________

All Replies
Black Belt

Re: How to map 1 value into the same row of another column in ETL

Is the Marketing Department the only department that is missing an Organization ID?

 

if all the other rows apart from marketing have a value in them, you could just use a replace text to replace any null or blank values with 4410.

 

otherwise you would need to filter just the marketing values first and then perform the replace text on the organization I’d field. 


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Visitor

Re: How to map 1 value into the same row of another column in ETL

Thank you! I ended up doing separate filters for each department that was missing an Organization ID and then using Value Mapper to populate the blank fields. I then appended the rows back together.

 

I did not use Replace Text because it does not work on numbers.

 

Thanks!!

Black Belt

Re: How to map 1 value into the same row of another column in ETL

I would encourage you to change the field type of any ID field to a string. Only use values for fields that you want to do calculations on


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!