Remove blank lines from an excel import

[ecabanas]

Hi guys,

I'm loading an excel file. After loading, there are 30 rows with data but there are  1048575 rows.

How could I import only the rows with data?

Thank's

Eduard

[Anil_Babu_Samineni]

What do you mean that

[tamilarasu · Accepted solution]

Hi Eduard,

Try like,

Load *

From

Source

WHERE(not IsNull(FieldName));    \\ It can be any not null field

[#4]

Hi,

While importing data from excel , in "File Wizard" window, Apply Conditional Delete (add compare with value->is empty function) condition in "Enable Transformation Step".

Thanks!

[miguelbraga]

Hey there,

Can you please send to us your script or even a sample of your qvw and/or sample of Excel file? Only then we can help you out

Best regards,

D.A. MB

[trdandamudi]

You can also try below:

Load *

From

Source

WHERE Len(Trim(FieldName)) > 0;    \\ It can be any field