how to mapped Key and Value?
Hello ,
I have key in one column and values in other column , i want to mapped them.
e.g. I have Columns
Key Values
A|B|C X|Y|Z
i want outpuy
Mapped
A=X|B=Y|C=Z
I have key in one column and values in other column , i want to mapped them.
e.g. I have Columns
Key Values
A|B|C X|Y|Z
i want outpuy
Mapped
A=X|B=Y|C=Z
Find more posts tagged with
Sort by:
1 - 2 of
21
Altair EmployeeHi,
sounds like a job for the Split operator 
Best,
Martin
I want to do like below mentioned
e.g. I have Columns Key and Value I want generate third column Mapped
Key Values Mapped
A|B|C X|Y|Z A=X|B=Y|C=Z
Generate concatination works but not I wanted it gives output like
A|B|C=X|Y|Z
e.g. I have Columns Key and Value I want generate third column Mapped
Key Values Mapped
A|B|C X|Y|Z A=X|B=Y|C=Z
Generate concatination works but not I wanted it gives output like
A|B|C=X|Y|Z