topic Re: Remove blank lines from an excel import in QlikView

Remove blank lines from an excel import

ecabanas — Wed, 28 Sep 2016 09:48:42 GMT

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

Re: Remove blank lines from an excel import

Anil_Babu_Samineni — Wed, 28 Sep 2016 10:00:13 GMT

What do you mean that

Re: Remove blank lines from an excel import

tamilarasu — Wed, 28 Sep 2016 10:27:56 GMT

Hi Eduard,

Try like,

Load *

From

Source

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

Re: Remove blank lines from an excel import

Wed, 28 Sep 2016 10:35:10 GMT

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!

Re: Remove blank lines from an excel import

miguelbraga — Wed, 28 Sep 2016 10:38:53 GMT

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

Re: Remove blank lines from an excel import

trdandamudi — Wed, 28 Sep 2016 11:15:14 GMT

You can also try below:

Load *

From

Source

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