Number | City |
---|
1000 | A | 1100 | B | 1200 | C | 1300 | D | E | 1400 | 1500 | F | 1300 | |
|
Hi Folks,
Need your help pls.
2 Questions -
1) In the table above, you could see that 1300 is mapped to city 'D' but in last row it is blank.
How do I map it using beast mode or Magic ETL to fill by Lookup in the same column.
Req: Lookup in 'Number' and fill Blanks in 'City'
2) 5th Row contains E in Number and 1400 in City. How do I exchange it to the right position using beast mode or Magic ETL?
Req: Case when 'Number' contains String value then City.
Case when 'City' contains Numeric value then 'Number'
Thanks in Advance!