Qlik Community

Ask a Question

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xuhao167
Contributor
Contributor

error:table not found,but the table exist actuallly,please see the attachment

when i debug the script,the error popup as attachment

1 Solution

Accepted Solutions
Quy_Nguyen
Creator III
Creator III

Hi,

The reason your final_table not found: from line 1-9 in your script, maybe a table has been created with fields: tx_date, kpos_amount, flow (call it Table A)

When you try to join kpos_table and ipva_table from line 10-13, the result table will be concatenated with Table A above (because Qlik auto concatenate tables which have all the same field names and number of fields)

Then final_table is not exists.


Addition: assumed that your final_table is correct after you change your script, code in line 15-16 will duplicate your data in final_table (follow the  auto concatenation )

So handling internal table in script load is very important.

View solution in original post

3 Replies
balabhaskarqlik

Maybe put NoConcatenate function above final_table1 statement & try.

Quy_Nguyen
Creator III
Creator III

Hi,

The reason your final_table not found: from line 1-9 in your script, maybe a table has been created with fields: tx_date, kpos_amount, flow (call it Table A)

When you try to join kpos_table and ipva_table from line 10-13, the result table will be concatenated with Table A above (because Qlik auto concatenate tables which have all the same field names and number of fields)

Then final_table is not exists.


Addition: assumed that your final_table is correct after you change your script, code in line 15-16 will duplicate your data in final_table (follow the  auto concatenation )

So handling internal table in script load is very important.

View solution in original post

xuhao167
Contributor
Contributor

put NoConcatenate function above final_table take effect but not final_table1