NoOfRows in Load Script as Variable to Store Table Into

[GaryMcDonald]

Hi,

Please could somebody explain where I'm going wrong here ?

I  want to store a table as a txt file but only if there are records in the table. 

When I use the function NoOfRows() as a variable using Let it always returns a NULL value thus the table is not saving as  a txt file.

Script Below:

Many thanks

Gary

[maxgro · Accepted solution]

Add ' '

LET vNumOfRows = NoOfRows('TableName');

[GaryMcDonald]

Awesome - Thanks Maxgro!