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
Updating RowNo with Corresponding Columnvalue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Thu Feb 07, 2013 5:19 am
Updating RowNo with Corresponding Columnvalue
Last edited by Sudhakarrendla on Thu May 02, 2013 11:39 pm, edited 3 times in total.
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?
![Confused :?](./images/smilies/icon_confused.gif)
As a guess, this looks like some kind of lookup. Is "IMONO" a table that holds the "corresponding columnvalue" you mentioned?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Updating RowNo with Corresponding Columnvalue
Analyze the values of input and output and can be use SCD stage or lookup stage
mgplk
-
- Participant
- Posts: 12
- Joined: Thu Feb 07, 2013 5:19 am
Re: Updating RowNo with Corresponding Columnvalue
Thanks to all for your reply. I have done this by using lookup( as BOB suggested)