Join Issue

[rajudx]

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

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

[ssreeni3]

Hi,
Pivot on Table B and Join.

I think this will work.

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

[ray.wurlod]

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.