Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get NB_LINE in tPostgresPlusRow?

Hi, I have a question.

 

t[DB]Output component have NB_LINE_(update/insert,delete,rejected) row, but t[DB]Row component doesn't have those NB_LINE, only have "ERROR_MESSAGE,QUERY".

 

How to get NB_LINE or deleted row count from the tPostgresPlusRow component?  

 

My query just " delete from [table] where a = 'some value' -->> want to get deleted row count.

 

Thanks,

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hello,

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.

Best regards

Sabrina