Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two column.
AA | BB | OutPut |
1 | a | a |
1 | a | a |
1 | a | |
2 | b | b |
2 | b | |
3 | c | c |
3 | c | c |
3 | c |
Now I have for 1 ->a and in some place 1 -> null so on the place of null I want a
Similarly for 2 ->b and in some place 2 -> null so on the place of null I want b
Similarly for 3 ->c and in some place 3 -> null so on the place of null I want c
Please find the attached xls for example.
Thanks
A Kumar
Hi,
Sorry I understood wrongly.
Use this
Table:
LOAD [AA ],
BB
FROM
[..\My Documents\Downloads\Test.xls]
(biff, embedded labels, table is Sheet1$);
LOAD
[AA ],
BB,
if(BB<>Null(),BB,Previous(BB)) as OutPut
Resident Table;
DROP Table Table;
Celambarasan
Hi,
Try with this approach
Table:
LOAD [AA ],
OutPut
FROM
Test.xls
(biff, embedded labels, table is Sheet1$);
Table1:
Load Distinct
[AA ],
BB
FROM
Test.xls
(biff, embedded labels, table is Sheet1$) Where BB<>null();
Left Join(Table)
Load
*
Resident
Table1;
DROP Table Table1;
Hope it helps
Celambarasan
Hi Celambarasan
I don't have any field like Output. I have created it for help.
I have only two column i.e AA and BB. Now we have to create a column like output with the help of this AA and BB Column.
Thanks for revert.
Hi,
Sorry I understood wrongly.
Use this
Table:
LOAD [AA ],
BB
FROM
[..\My Documents\Downloads\Test.xls]
(biff, embedded labels, table is Sheet1$);
LOAD
[AA ],
BB,
if(BB<>Null(),BB,Previous(BB)) as OutPut
Resident Table;
DROP Table Table;
Celambarasan
Thanks.
Don't say sorry, It was my mistake, I didn't mentioned it.
Thanks again.
A Kumar