-
Re: NoOfTables() function is not returning a true value
Petter Skjolden Nov 19, 2017 7:06 AM (in response to yaman alsaadi)I tested on my Qlik Sense November 2017 with my own test file. The result was correct for NoOfTables() being called at the end of my script.
Which version of Qlik Sense are you using? Could you provide your entire script or at least the portion that includes the LOAD and the following call to the NoOfTables() function?
-
Re: NoOfTables() function is not returning a true value
yaman alsaadi Nov 19, 2017 7:11 AM (in response to Petter Skjolden )LIB CONNECT TO 'DEV1-PC-MSSQLSERVER2014 (desktop-dpummb2_yaman)';
SQL select * from ComplexType;
Generic LOAD
ParentID,Name,ID;
// com:
// load * from [lib://personal (desktop-dpummb2_yaman)/Persimmon/Persimmon1.qvd];
Set vListOfTables1 = ;
let Nof.list=0;
//initialize the lists which each one will contain tables have the same Key
for c=1 to 4
let list$(c)=" ";
next c;
let u=NoOfTables(); //i get here 1
-
Re: NoOfTables() function is not returning a true value
yaman alsaadi Nov 19, 2017 7:23 AM (in response to Petter Skjolden )i am using Qlik Sense Server 2017
also i have tested with other app the result was correct but here not working !!!!
-
Re: NoOfTables() function is not returning a true value
Stefan Wühl Nov 19, 2017 8:17 AM (in response to yaman alsaadi)What is the source of your generic load?
Since you have commented out the QVD LOAD, I can't see a valid source.
Maybe this explains your missing table count.
-
Re: NoOfTables() function is not returning a true value
yaman alsaadi Nov 19, 2017 9:23 AM (in response to Stefan Wühl )the source is Sql server 2014
the data is one table called ComplexType
after loading data from there as generic load it considers the original table only.
-
Re: NoOfTables() function is not returning a true value
Stefan Wühl Nov 19, 2017 10:11 AM (in response to yaman alsaadi)No, I am talking about this script statement:
Generic LOAD
ParentID,Name,ID;
This LOAD statement needs a table source, i.e. a FROM ... or RESIDENT ...
(Or a subsequent LOAD statement, i.e. it works as preceding LOAD on another LOAD).
Maybe your script you've posted is not the one you've actually used in your test or you posted it incomplete.
Please recheck and post your complete relevant script.
-
Re: NoOfTables() function is not returning a true value
yaman alsaadi Nov 20, 2017 3:17 AM (in response to Stefan Wühl )Yes thanks Mr. Stefan.
Firstly i connected to Sql server using this statement :LIB CONNECT TO 'DEV1-PC-MSSQLSERVER2014 (desktop-dpummb2_yaman)';
after that i want to create generic tables using that sql source which actually has one table called Complex type but really i dont know how can type that after this statement
Generic LOAD
ParentID,Name,ID;
From ???
-
Re: NoOfTables() function is not returning a true value
Stefan Wühl Nov 20, 2017 4:25 AM (in response to yaman alsaadi)See your other thread (in short, use SELECT).
I would appreciate keeping one issue to one thread, though.
-
-
-
-
-
-