write a condition in script to check whether data is avalable or not in table.

[#1]

hi,

HOW TO @write a condition in script to check whether data is avalable or not in table.QlikTech Admin

[kaushiknsolanki]

Hi,

     What do you mean by "Data is available or not". Kindly elaborate in detail.

Regards,

Kaushik Solanki

[#3]

Hi,

You can use filter condition in load script using "Where" clause, something like:

Temp:

Load
Field1,

Field2,

Field3

........

Where Field1 = 'A'

And you can add more conditions per your requirement.

Hope this helps!

[jagan]

Hi Pankaj,

Tru NoOfRows(), please check example below

NoOfRows('TableName ' )

Returns the number of rows (records) in a previously loaded table.

If the function is used within a load statement, it must not reference the table currently being loaded.

Examples:

LET vRowCount = NoOfRows('tab1');

Get the rows count in table tab1 and stores it in variable vRowCount and use this variable with IF THEN ELSE.

Hope this helps you.

Regards,

Jagan.