topic Re: fields not getting acknowledged while loading from a source file in QlikView

fields not getting acknowledged while loading from a source file

Fri, 14 Nov 2014 06:39:42 GMT

Hi,

I am trying to count the number of fields that are there in the source file before the load,

I use the following code:

[Source]:

LOAD *

FROM

$(vFile)

(biff, embedded labels, table is [Sheet1$]);

LET vSource = NoOfFields('Source');

But when I check the value of the variable vSource, it's blank (<NULL>).

I checked the value of vFile variable as well which has the correct file path.

I checked the file, it has 26 fields.

Any clue what could be wrong?

sujeetsingh — Fri, 14 Nov 2014 06:53:55 GMT

It should work try loading it to a Temp table

Fri, 14 Nov 2014 06:55:31 GMT

also, for another very similar file, which has a column less, it works perfectly.Any help?

SergeyMak — Fri, 14 Nov 2014 06:58:07 GMT

Hi,

If you have an issue with a specific file it would be better to share it. It would be great if you share your app as well.

Regards,

Sergey