https://community.qlik.com/t5/Talend-Studio/Single-Insert-Query-in-DB-output/m-p/2314545#M85298 hello, I have a problem <BR />at tmap when processing flows before isertion of chque line, I want to take the previous value of a field in the output table and manipulate it to get the next value <BR />each line we have ID = MAX (ID) +1 Wed, 02 Jul 2014 06:43:22 GMT Anonymous 2014-07-02T06:43:22Z https://community.qlik.com/t5/Talend-Studio/Single-Insert-Query-in-DB-output/m-p/2314544#M85297 hi all, <BR />there is a mode in DB output component with a 'Single Insert Query'. <BR />Help center say it's a batch mode. <BR />what the difference by using the advanced setting batch size (extended insert) witn insert mode (that exist as far as I could remember) ?? <BR /> <BR />thanks for advice <BR />regards <BR />laurent Wed, 25 Jun 2014 15:22:51 GMT https://community.qlik.com/t5/Talend-Studio/Single-Insert-Query-in-DB-output/m-p/2314544#M85297 Anonymous 2014-06-25T15:22:51Z https://community.qlik.com/t5/Talend-Studio/Single-Insert-Query-in-DB-output/m-p/2314545#M85298 hello, I have a problem <BR />at tmap when processing flows before isertion of chque line, I want to take the previous value of a field in the output table and manipulate it to get the next value <BR />each line we have ID = MAX (ID) +1 Wed, 02 Jul 2014 06:43:22 GMT https://community.qlik.com/t5/Talend-Studio/Single-Insert-Query-in-DB-output/m-p/2314545#M85298 Anonymous 2014-07-02T06:43:22Z