fields not getting acknowledged while loading from a source file

[#1]

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]

It should work try loading it to a Temp table

[#3]

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

[SergeyMak]

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