How to get distint count from salesforce table

[hangel]

Hi ,

I'm trying to combine multi resulted values from unique column in separate column and have to provide a unique name.

for explame

S.No Product Name

190 PORTS Materials

190 Router Materials

190 Cable Materials

But when i do distinct i must get only 1 record for above entry.

Is this feasible in talend?

for explame

S.No  Product  Name

190      PORTS  Materials

190     Router Materials

190     Cable  Materials

191 PORTS Material

Here i must get 2 record for above entry. Is this feasible in talend?

Talend Job build using this flow --> salesforce -> tmap -> store in influxdb - Showing in Grafana

I'm looking for a solution for this challenging logic. Thanks

[dramya]

@Manohar B​  - Does the details given in the attachment help?

[manodwhb]

@RAMYA DHANASEKARAN​ , is your data is static that you will have same this way like 1 will have IP and 2 will have static and 3 will have others?

Thanks,

Manohar

[dramya]

@Manohar B - No it is not static combination it is a Dynamic list. however Data-wise category has to b done based on these 3 types: IP , Static & Others by looking in to the combination for serial no.

[manodwhb]

@dramya, to support your requirement ,we do not have direct component, But you can create a java routine and you use in talend get that way.

Thanks,

Manohar