how to mapped Key and Value?

sgnarkhede2016

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

MartinLiebig

Hi,

sounds like a job for the Split operator

Best,

Martin

sgnarkhede2016

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