topic Re: Count of rows in script post left join? in QlikView

Count of rows in script post left join?

punitpopli — Wed, 28 Mar 2018 06:47:35 GMT

Hi Experts,

Could you please let me know if we can extract the count of a table in a variable post left join?

details in below :

Load

From [QVD_A]qvd;

Left Join

Load

From [QVD_B]qvd;

//Count after the b joining A,

I tried Let vVarA = noOfRows(A);

TRACE $(A); but this is not working

Left Join

Load

From [QVD_C]qvd;

//Count after the C joining A..

Left Join

😧

Load

From [QVD_D]qvd;

//Will get final Count of all the tables once reload finish.

Re: Count of rows in script post left join?

vardhancse — Wed, 28 Mar 2018 06:54:36 GMT

Hi,

can change the variable as below:

Let vVarA = NoOfRows('Tablename');

** please note '' is missing in your table name

now if we use the variable in front end then we can get the total count

=$(vVarA)

Please note if we do left join, then only the related information from Table A will be loaded from rest of the tables.

And since we are concatenating with multiple tables the count in variable will reflect total rows from all the tables

Re: Count of rows in script post left join?

jonathandienst — Wed, 28 Mar 2018 07:00:19 GMT

The table name needs quotes

...NoOfRows('A')

Re: Count of rows in script post left join?

prasad_dumbre — Wed, 28 Mar 2018 07:02:12 GMT

Hi Punit, Post your join logic, take a resident of table create a metadata table. Example: LOAD 'A' as TableName, NoOfRows('A') as TableRows Resident 'A'; Depending on your requirement you can use this table as it is or pull info from it & store it in variable.

Re: Count of rows in script post left join?

punitpopli — Wed, 28 Mar 2018 07:09:51 GMT

Hi vardhancse‌

Tried with both single qoute an double quote but this is not working.

This worked Thank you

Re: Count of rows in script post left join?

punitpopli — Wed, 28 Mar 2018 07:10:52 GMT

Hi jontydkpi‌

Tried with both single qoute an double quote in table name, but is not working for me.

This worked Thank you

Re: Count of rows in script post left join?

vardhancse — Wed, 28 Mar 2018 08:24:40 GMT

Good that you were able to get the solution.

Please mark is as correct answer so that it might be helpful to others