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

[manodwhb]

@Angel Hemu​ , yes you can do that for the below input.

for explame

S.No Product Name

190 PORTS Materials

190 Router Materials

190 Cable Materials

you want to get the output only one record means you can remove duplicates on S.No column in tUniqueRows.but if you want to get the specific record then you need to sort the before tUniqueRows component using tSortRows.

Similarly you can two records from the below input using the same above mention way.

S.No Product Name

190     PORTS Materials

190    Router Materials

190    Cable Materials

191 PORTS Material

[hangel]

Hi

manodwhb,

Thanks for your reply !

I tried the solution you have provided. Here i tried with a record which holds 78 entries.

Using tUnique component i finally got 1 records in tlogrow output. which gives me distinct value of that record. How ever i miss the valid data product list of the record.

Still i feel I didn't get the expected result. Can you tell me whether it is feasible to add new column to tell me whether it is Standalone (Single) or Multiple Category using the S.No?

S.No Product Name UNIQUE NAME

190 PORTS Materials Multiple

190 Router Materials Multiple

190 Cable Materials Multiple

191 PORTS Single

Is the above one is feasible?

[hangel]

Actually @Manohar B​ I'm trying to achieve the scenario using below tmap

condition

(out.Product_Name__c.equals("Dynamic IP") ? "Dynamic_IP" :

(out.Product_Name__c.equals("SD WAN") ? "SD_WAN" : "Others" ) ) 

I'm able to get the data in nprod column as in the image which is attached. I'm able to get "Dynamic IP" data correctly.

There are scenarios where I want to achieve "SD WAN" data alone but it should not have Dynamic IP data , How to achieve it with entry(eg.serial no) do not have Dynamic IP by excluding SD WAN data which has Dynamic IP data.

[manodwhb]

@Angel Hemu​ ,can you share your tMap configuration screenshot ?

[hangel]

@Manohar B​ Attached the tmap image

[manodwhb]

@Angel Hemu​ ,where is nprod  column /field? and can you give sample input and output what you want?

[hangel]

@Manohar B​ prod is referred as nprod is the expresssion(out1).

I want to categorize the data in to 3 types (Dynamic IP , SD WAN , Others) using the combination mentioned below:(Sample) - Each Serial no. may have n number of products.

1. My input data (Product Name_c) carries multiple product which has Dynamic IP/SD WAN and other combinations for each serial no.

2. My output should be if i have Dynamic IP/SD WAN and Other Product - I must get "Dynamic IP" as the output for that record.

3. If there is no Dynamic IP and if i have SD WAN then my output should come as "SD WAN"

4. If there is no Dynamic IP & SD WAN then my output should come as "Others"

Does this suffice?(Sample Screenshot attached)

[dramya]

@Manohar B​ - Do we have any solution for this ?

[manodwhb]

@RAMYA DHANASEKARAN​ , I have not understand clearly about the requirement here.