topic How to get distint count from salesforce table in Talend Studio

How to get distint count from salesforce table

hangel — Sat, 16 Nov 2024 01:52:00 GMT

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

Re: How to get distint count from salesforce table

manodwhb — Sat, 18 Jul 2020 03:01:16 GMT

@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

Re: How to get distint count from salesforce table

hangel — Mon, 20 Jul 2020 07:49:43 GMT

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?

Re: How to get distint count from salesforce table

hangel — Wed, 12 Aug 2020 23:21:36 GMT

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.

Re: How to get distint count from salesforce table

manodwhb — Thu, 13 Aug 2020 01:23:16 GMT

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

Re: How to get distint count from salesforce table

hangel — Thu, 13 Aug 2020 05:42:08 GMT

@Manohar B Attached the tmap image

Re: How to get distint count from salesforce table

manodwhb — Thu, 13 Aug 2020 07:41:59 GMT

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

Re: How to get distint count from salesforce table

hangel — Thu, 13 Aug 2020 08:33:25 GMT

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

Re: How to get distint count from salesforce table

dramya — Fri, 14 Aug 2020 18:24:14 GMT

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

Re: How to get distint count from salesforce table

manodwhb — Mon, 17 Aug 2020 04:54:15 GMT

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

Re: How to get distint count from salesforce table

dramya — Mon, 17 Aug 2020 16:25:07 GMT

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

Re: How to get distint count from salesforce table

manodwhb — Mon, 17 Aug 2020 16:33:48 GMT

@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

Re: How to get distint count from salesforce table

dramya — Tue, 18 Aug 2020 06:08:44 GMT

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

Re: How to get distint count from salesforce table

manodwhb — Tue, 18 Aug 2020 11:50:52 GMT

@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