e.g
Code: Select all
Table A Table B
CID CID1,CID2,CITY
230 230,560,NJ
450 450,340,WC
560
340
Output
------
230,NJ
450,WC
560,NJ
340,WC
Source column have only one column and target table data presented on two columns and we are unable to use join/lookup stage, because those need to be setup on equal column names from source/target.
Please let me know which stage or process we need to use to get the output as mentioned above.
Thanks,
Raju