topic Re: error:table not found,but the table exist actuallly,please see the attachment in Integration, Extension & APIs

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

Anonymous — Thu, 28 Jun 2018 08:04:25 GMT

when i debug the script,the error popup as attachment

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

BalaBhaskar_Qlik — Thu, 28 Jun 2018 18:01:56 GMT

Maybe put NoConcatenate function above final_table1 statement & try.

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

Quy_Nguyen — Thu, 28 Jun 2018 18:49:25 GMT

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.

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

Anonymous — Fri, 29 Jun 2018 02:44:56 GMT

put NoConcatenate function above final_table take effect but not final_table1