Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

hi,

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

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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
Luminary Alumni
Luminary Alumni

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.