https://community.qlik.com/t5/Talend-Studio/How-to-get-NB-LINE-in-tPostgresPlusRow/m-p/2330907#M99943 <P>Hello,</P> <P><SPAN>There is no global variable like ((Integer)globalMap.get("tPostgresPlusOutput_1_NB_LINE_DELETED")) available if you use tPostgresPlusRow to execute the statements, if you want to count the number of rows are deleted or updated, you have to use tPostgresPlusOutput to do it.<BR /></SPAN></P> <P><SPAN>Best regards</SPAN></P> <P><SPAN>Sabrina</SPAN></P> Wed, 15 Nov 2017 09:01:08 GMT Anonymous 2017-11-15T09:01:08Z https://community.qlik.com/t5/Talend-Studio/How-to-get-NB-LINE-in-tPostgresPlusRow/m-p/2330906#M99942 <P>Hi, I have a question.</P> <P>&nbsp;</P> <P>t[DB]Output component have&nbsp;NB_LINE_(update/insert,delete,rejected) row, but t[DB]Row component doesn't&nbsp;have those NB_LINE, only have "ERROR_MESSAGE,QUERY".</P> <P>&nbsp;</P> <P>How to get NB_LINE or deleted row count from the tPostgresPlusRow component?&nbsp;&nbsp;</P> <P>&nbsp;</P> <P>My query just " delete from [table] where a = 'some value' --&gt;&gt; want to get deleted row count.</P> <P>&nbsp;</P> <P>Thanks,</P> Wed, 15 Nov 2017 08:37:48 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-NB-LINE-in-tPostgresPlusRow/m-p/2330906#M99942 Anonymous 2017-11-15T08:37:48Z https://community.qlik.com/t5/Talend-Studio/How-to-get-NB-LINE-in-tPostgresPlusRow/m-p/2330907#M99943 <P>Hello,</P> <P><SPAN>There is no global variable like ((Integer)globalMap.get("tPostgresPlusOutput_1_NB_LINE_DELETED")) available if you use tPostgresPlusRow to execute the statements, if you want to count the number of rows are deleted or updated, you have to use tPostgresPlusOutput to do it.<BR /></SPAN></P> <P><SPAN>Best regards</SPAN></P> <P><SPAN>Sabrina</SPAN></P> Wed, 15 Nov 2017 09:01:08 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-NB-LINE-in-tPostgresPlusRow/m-p/2330907#M99943 Anonymous 2017-11-15T09:01:08Z