Six Stars

tPostgresqlRow not working

Hi community

 

I am getting NO results back from my tPostgresqlRow. All fields return null:

Job

tpostgresqlrow.png

Sql for tPostgresqlInput_1:

select distinct (account_id) as account_id from edw_dev.d_customer_account
 where account_id in( '1-DXQFNF') ;

Sql for tPostgresqlRow_1

select distinct account_id,account_sk from edw_dev.d_customer_account
 where account_id in ( '"+((String)globalMap.get("row1.account_id"))+"' )

Schema Config for tPostgresqlRow_1:

tpostgresqlrowConfig.png

 

 

  • Data Integration
  • ESB
1 ACCEPTED SOLUTION

Accepted Solutions
Nine Stars

Re: tPostgresqlRow not working

to continue our discussion

 

use tPostgreSQLInput instead or tPostgreSQLRow  if You want return data

use the same query, just change component

 

or look for - https://help.talend.com/search/all?query=Configuring+the+tParseRecordSet+component

-----------
2 REPLIES
Nine Stars

Re: tPostgresqlRow not working

to continue our discussion

 

use tPostgreSQLInput instead or tPostgreSQLRow  if You want return data

use the same query, just change component

 

or look for - https://help.talend.com/search/all?query=Configuring+the+tParseRecordSet+component

-----------
Six Stars

Re: tPostgresqlRow not working

Thank you, what is the purpose then of tPostgresqlRow?