topic Re: write a condition in script to check whether data is avalable or not in table. in QlikView

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

Thu, 12 Dec 2013 06:33:35 GMT

hi,

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

kaushiknsolanki — Thu, 12 Dec 2013 06:36:50 GMT

Hi,

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

Regards,

Kaushik Solanki

Thu, 12 Dec 2013 06:37:53 GMT

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 — Thu, 12 Dec 2013 07:51:26 GMT

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.