DSXchange

Hi All,

I have got some requirement,if you got any workaround to get o/p please reply back.

In columnName,'D'(i.e IMNO) corresponding Columnvalue needs to updated in corresponding group of RowNo.

I/P:

RowNo ColumnName ColumnValue
1 A A8XL6
1 B 16-Mar-06
1 C SEAWAY CONDOR
1 D 9494022
1 E 14465
1 F 1994
3 A ELXL9
3 B 26-Nov-10
3 C NULL
3 D 8111879
3 E 14926
3 F 2004


O/P:


RowNo ColumnName ColumnValue
9494022 A A8XL6
9494022 B 16-Mar-06
9494022 C SEAWAY CONDOR
9494022 D 9494022
9494022 E 14465
9494022 F 1994
8111879 A ELXL9
8111879 B 26-Nov-10
8111879 C NULL
8111879 D 8111879
8111879 E 14926
8111879 F 2004

You will need to explain this in more detail before anyone can do anything other than guess what needs to happen here. I'd also be curious what you've tried so far or if you just came here and posted your work assignment.

As a guess, this looks like some kind of lookup. Is "IMONO" a table that holds the "corresponding columnvalue" you mentioned?

Analyze the values of input and output and can be use SCD stage or lookup stage

As far I understood
by using lookup we can get this, send the 'IMONo' data for a reference link and all the data again send to direct link, by which make a lookup/join with rownum, which will place appropriate values.
let me know if this process does not work.

Thx

Thanks to all for your reply. I have done this by using lookup( as BOB suggested)