https://community.qlik.com/t5/Talend-Studio/NB-Line-INSERTED-not-returning-correct-result/m-p/2237633#M25998 I verified that tMSSqlOutput_1 to indeed inserting records (truncate then insert). <BR />However, when I use the following code, it is not assigning the inserted numbers. It returned -1. <BR /> <BR />context.QATargetInserted=context.QATargetInserted+((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_INSERTED")); <BR />Confusing part is the following code IS RETURNING CORRECTLY. <BR /> <BR />context.QATarget=context.QATarget+((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE")); <BR />Any reason why? Sat, 16 Nov 2024 13:22:48 GMT Anonymous 2024-11-16T13:22:48Z https://community.qlik.com/t5/Talend-Studio/NB-Line-INSERTED-not-returning-correct-result/m-p/2237633#M25998 I verified that tMSSqlOutput_1 to indeed inserting records (truncate then insert). <BR />However, when I use the following code, it is not assigning the inserted numbers. It returned -1. <BR /> <BR />context.QATargetInserted=context.QATargetInserted+((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE_INSERTED")); <BR />Confusing part is the following code IS RETURNING CORRECTLY. <BR /> <BR />context.QATarget=context.QATarget+((Integer)globalMap.get("tMSSqlOutput_1_NB_LINE")); <BR />Any reason why? Sat, 16 Nov 2024 13:22:48 GMT https://community.qlik.com/t5/Talend-Studio/NB-Line-INSERTED-not-returning-correct-result/m-p/2237633#M25998 Anonymous 2024-11-16T13:22:48Z