DSXchange

Posted: **Tue May 14, 2013 7:04 am**

As per the requirement we need to make join on two columns with one column.

e.g

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

Posted: **Tue May 14, 2013 7:46 am**

Hi,
Pivot on Table B and Join.

I think this will work.

--------------
Sreeni

Posted: **Tue May 14, 2013 6:20 pm**

Use a Copy or Modify stage to change the name of the join key column on one of the input links so that it matches the name used on the other input link.

DSXchange

Join Issue

Join Issue