Null Maping
Posted: Thu Oct 12, 2006 12:38 pm
hi
I have seq input file and Lkup file in following way and total no of rows is around 10000
seq file lkup file
1 1
null null
2 2
3 3
null null
4 4
when i do match with not(notfound(lkupfile)) i am getting only rows which are not null .
but i want to return all the rows.
please share your thought
sai
I have seq input file and Lkup file in following way and total no of rows is around 10000
seq file lkup file
1 1
null null
2 2
3 3
null null
4 4
when i do match with not(notfound(lkupfile)) i am getting only rows which are not null .
but i want to return all the rows.
please share your thought
sai