topic How to get row count based on column in salesforce component in Talend Studio

How to get row count based on column in salesforce component

dramya — Sat, 16 Nov 2024 01:39:30 GMT

@shong How to get count of record if it has more than 1 record using particular column in salesforce component??

Re: How to get row count based on column in salesforce component

Anonymous — Tue, 18 Aug 2020 01:09:41 GMT

@RAMYA DHANASEKARAN , you can use the global variable such as ((Integer)globalMap.get("tSalesforceInput_1_NB_LINE"))

Re: How to get row count based on column in salesforce component

dramya — Tue, 18 Aug 2020 03:26:16 GMT

Hi @shong - Thanks , So i have to use tjava to acheive this right ? Please correct me if im wrong. Also how to map the count data in to seperate column?

Re: How to get row count based on column in salesforce component

Anonymous — Tue, 18 Aug 2020 03:36:33 GMT

This variable is only available in next subjobs, eg:

tSalesForceInput--main--tLogRow

|onsubjobok

tJava

on tJava, you can print the value of variable on the console or assign it to context variable.

Re: How to get row count based on column in salesforce component

dramya — Tue, 18 Aug 2020 11:33:36 GMT

@shong - Thanks ! it worked and gave the overall row count for the data which fetched from salesforce component.

I'm look for the coun of coumn data which come from the salesforce component and map it to a separate output. Eg Below: here i must get Roll no value as 111- 2 , 122 -1 , 166- 3 - Is it feasible?

S.No Roll No.