How to get row count based on column in salesforce component

[dramya]

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

[Anonymous]

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

[dramya]

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?

[Anonymous]

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.

[dramya]

@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.

1. 111
2. 111
3. 122
4. 166
5. 166
6. 166