How can I get a count of selection criteria ( select count(*) from abc ) from database (tRedshiftInput)

[Anonymous]

How can I get a count of selection criteria ( select count(*) from abc ) from database (tRedshiftInput). I tried the following in tJavaRow right after tRedshiftInput, but got null value

globalMap.get("****"+(Integer)globalMap.get("tRedshiftInput_3_NB_LINE"));

[Anonymous]

Hello,

((Integer)globalMap.get("tRedshiftInput_1_NB_LINE")) does count the total number of selected rows. 

You can also use tfixedflow component to print ((Integer)globalMap.get("tRedshiftInput_1_NB_LINE")) into console. let us know if tfixedflow component is OK with you.

Best regards

Sabrina

[Anonymous · Accepted solution]

Thanks so much Sabrina.

Yes, it worked when I connected tRedShiftInput to tJava with OnComponentOk.

Soma