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

[Anonymous]

when i debug the script,the error popup as attachment

[balabhaskarqlik]

Maybe put NoConcatenate function above final_table1 statement & try.

[Quy_Nguyen · Accepted solution]

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.

[Anonymous]

put NoConcatenate function above final_table take effect but not final_table1