multiple columns to single column lookup
Posted: Wed Jan 23, 2013 4:28 am
Hi,
An input file has column defintion as Id, StatusCode1, StatusCode2,...StatusCode82 and a table has column definition as StatusCode. If any one of the StatusCode (StatusCode1 to StatusCode82) from input file matches with table's StatusCode then that record has to go to one link otherwise it has to go to another link. The StatusCode in table is dynamic which means there can be 3 status codes now and some more status codes can be added in future.
Input sample data:
123,AB,CD,EF,.....XY
124,BA,DC,EF,.....YX
125,BD,CE,AF,.....XZ
Table data:
CD
GH
RT
From the above first record has to go to link1 since StatusCode2 (CD) present in table also, another 2 records has to go to link2 since none of the StatusCode from these 2 records is present in the table.
An input file has column defintion as Id, StatusCode1, StatusCode2,...StatusCode82 and a table has column definition as StatusCode. If any one of the StatusCode (StatusCode1 to StatusCode82) from input file matches with table's StatusCode then that record has to go to one link otherwise it has to go to another link. The StatusCode in table is dynamic which means there can be 3 status codes now and some more status codes can be added in future.
Input sample data:
123,AB,CD,EF,.....XY
124,BA,DC,EF,.....YX
125,BD,CE,AF,.....XZ
Table data:
CD
GH
RT
From the above first record has to go to link1 since StatusCode2 (CD) present in table also, another 2 records has to go to link2 since none of the StatusCode from these 2 records is present in the table.