How to ignore empty lines in tab delimited files?

[#1]

I have some tab delimited files to be used as source, but some of them come with rows at the end that contain tabs and no data.

How can I ignore these rows at the end?

Thanks,

Miguel

[salto]

Hello Miguel,

QlikView does ignore those lines, doesn't it? They are not imported I think.

[Gysbert_Wassenaar]

Qlikview won't load lines that are completely empty. If you do end up with records that contain only nulls you can try checking for nulls in a column that should always have a value:

Table1:

Load A, B, C, ...etc

From ...somewhere...

Where len(trim(A)) > 0;

The where clause above will make sure only those records are loaded in which field A contains a value.

[#4]

Something is wrong. I debugged using qlikviewer and the data gets loaded.

But when I show it in a Raw table, it doesn't show anything!!!!!

[#5]

Miguel, por lo general esto pasa cuando tienes 2 tablas referenciadas con 2 o mas llaves primarias, recuerda que por buenas practicas en qlikview se debe tenere una llave primaria por conexion de tabla, saluds y suerte!!

[#6]

No I'm just referencing one table....

[#7]

Do you have an Example?

[#8]

Here's an example attached.

[#9]

Look at the difference is an Bussines Law,

i attach you the example ,

Regards!!!

[#10]

I got the difference. You use the sum(test) instead of test. But why doesn't it work using just the column test as expression?