load the data based on condition?

[daisy1438]

Hi

i have one example table below like

a1 ,             b1,        ,c1

uk               1200     laptop

us                1400    tv 

-missing-      -1        ffffffff

-missing-      -1         ffffffffff

India           2000      mobile

India           3000      sim

-missing-     -1          ffffffff

above table a1,b1,c1 are the fields.whiie loading time remove the missing data.

reqired output below like.

a1 ,             b1,        ,c1

uk               1200     laptop

us                1400    tv 

India           2000      mobile

India           3000      sim

thanks

daisy

[Anil_Babu_Samineni]

Load Script? Try this

Load * From Table Where a1 <> '-missing';

[shiveshsingh]

load *

from T where a1 <> '-missing- '

Are you giving it a try?

Your response is not coming in your previous posts!

[Anonymous]

Try this way

while loading data Enable Data Transformation and select the "Remove the selected Record" that will remove the missing and you can load the data as per your out put.