topic Re: Issue in table creation in QlikView

Issue in table creation

Wed, 25 Nov 2020 16:16:04 GMT

I have actually two tables in a database for hive.

DB Name : test_db

table_a & table_b.

Once script is run , in sheet properties, we have only one table in Show Fields from table dropdown.

Table labels are getting updated in for loop and only table a is getting dropped

Below is the code

//Connect to hive

ODBC CONNECT TO hpc_hive;

SQL use test_db;

SQL show tables;

LET vTablecount=NoOfRows('a');

For i=0 To $(vTablecount) -1

LET vTablename=Peek('tab_name',$(i),'a');

LET vMyTableNameQVD =Peek('tab_name',$(i),'a');

$(vTablename):

SQL desc $(vTablename);

Next i;

DROP Table a;

Re: Issue in table creation

rahulpawarb — Wed, 22 Mar 2017 06:31:57 GMT

Hello Ashwin,

Trust that you are doing well!

Have you verified the no. of rows hold by table a (before dropping table a; you can do it by commenting every statement after SQL show tables;).

Please correct me if I am wrong.

Regards!

Rahul

Re: Issue in table creation

Wed, 22 Mar 2017 07:11:13 GMT

No.of rows is equal to 2 before dropping table a.

Re: Issue in table creation

rahulpawarb — Wed, 22 Mar 2017 07:20:18 GMT

Hello Ashwin,

As per my understanding tables are getting auto concatenated. To avoid this please use NoConcatenate statement before the table name of load statement.

//Connect to hive
ODBC CONNECT TO hpc_hive;
a:
SQL use test_db;
SQL show tables;
LET vTablecount=NoOfRows('a');
For i=0 To $(vTablecount) -1
LET vTablename=Peek('tab_name',$(i),'a');
LET vMyTableNameQVD =Peek('tab_name',$(i),'a');
NoConcatenate 
$(vTablename):
SQL desc $(vTablename);
Next i;
DROP Table a;

Hope this will be helpful.

Regards!

Rahul

Re: Issue in table creation

Thu, 23 Mar 2017 10:32:27 GMT

Thanks Rahul it is working fine now.

Re: Issue in table creation

rahulpawarb — Thu, 23 Mar 2017 10:39:24 GMT

Cheers,

Rahul

Re: Issue in table creation

Thu, 23 Mar 2017 10:48:25 GMT

Tables are shown separately in sheet properties but the column names are not filtering according to the table since the header name is same for both tables. Can you help me out in this.

Re: Issue in table creation

rahulpawarb — Thu, 23 Mar 2017 10:55:08 GMT

Hello Ashwin,

Could you please share the application with sample data? This will help me to understand the situation and provide you required inputs.

Regards!

Rahul