topic Re: Implement logic with tMap in Talend Studio

Implement logic with tMap

Anonymous — Sat, 16 Nov 2024 03:48:30 GMT

Hello Gurus,

Need your suggestions / help to Implement Business Logic by using tMap component. I am quite familiar with Talend platform but not into Advanced.

I have 4 standard values called RGBW = ["Red", "Blue", "Green", "White"]

My Input file should as follows,

Secure_Date, TimeResolution, Hypothesis, Quality, Value
08.12.2019 23:00,15 MIN,ACTUAL,100,23.12
08.12.2019 23:00,15 MIN,ACTUAL,100,37.90
08.12.2019 23:00,15 MIN,ACTUAL,100,67.879
08.12.2019 23:00,15 MIN,ACTUAL,100,120.67
08.12.2019 23:15,15 MIN,ACTUAL,100,90.67
08.12.2019 23:15,15 MIN,ACTUAL,100,43.89
08.12.2019 23:15,15 MIN,ACTUAL,100,12.67
08.12.2019 23:15,15 MIN,ACTUAL,100,66.23
.
.
.

My Output should be,

Product_Name,Creation_Date,Fulfillment_DateTime,Days_Ahead,Value,RGBW
20 Liter Box,null,12/8/2019 22:00,null,23.12,Red
20 Liter Box,null,12/8/2019 22:00,null,37.90,Green
20 Liter Box,null,12/8/2019 22:00,null,67.879,Blue
20 Liter Box,null,12/8/2019 22:00,null,120.67,White
20 Liter Box,null,12/8/2019 22:15,null,90.67,Red
20 Liter Box,null,12/8/2019 22:15,null,43.89,Green
20 Liter Box,null,12/8/2019 22:15,null,12.67,Blue
20 Liter Box,null,12/8/2019 22:15,null,66.23,White
.
.
.

Please suggest me how to proceed to load above output file.

Thanks for your suggestions in advance.

Thanks,

Nag

Re: Implement logic with tMap

manodwhb — Tue, 17 Dec 2019 12:14:08 GMT

@ris.tan ,need more details on ,how to get

Product_Name and RGB fields?

Re: Implement logic with tMap

Anonymous — Tue, 17 Dec 2019 16:49:59 GMT

Hello Manohar,

Thanks for your message. Product_Name and RGBW are constants and need to load as Default.

Thanks,

Nag

Re: Implement logic with tMap

manodwhb — Wed, 18 Dec 2019 07:16:04 GMT

@ris.tan , how you will define the constant for the particular record is Red or Green or Blue or White ?

Re: Implement logic with tMap

Anonymous — Wed, 18 Dec 2019 09:15:52 GMT

@manodwhb, This is what to define the Logic.

Re: Implement logic with tMap

Anonymous — Wed, 18 Dec 2019 14:39:32 GMT

Hi,

Could you please tell us the logic of adding the colour to your output data? Right now its quite ambiguous and there seems to be no relationship between input and output.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Implement logic with tMap

Anonymous — Fri, 20 Dec 2019 09:13:15 GMT

Hello Nikhil,

I have standard values which have defined as

RGBW = ["Red", "Blue", "Green", "White"]

Now, my output should as follows,

Product_Name,Creation_Date,Fulfillment_DateTime,Days_Ahead,Value,RGBW
20 Liter Box,null,12/8/2019 22:00,null,23.12,Red
20 Liter Box,null,12/8/2019 22:00,null,37.90,Green
20 Liter Box,null,12/8/2019 22:00,null,67.879,Blue
20 Liter Box,null,12/8/2019 22:00,null,120.67,White
20 Liter Box,null,12/8/2019 22:15,null,90.67,Red
20 Liter Box,null,12/8/2019 22:15,null,43.89,Green
20 Liter Box,null,12/8/2019 22:15,null,12.67,Blue
20 Liter Box,null,12/8/2019 22:15,null,66.23,White
.
.
.

From above result, want to load first record with the default RGBW = "Red"

and second output record of the RGBW value should be "Green", third output record of the RGBW value should be "Blue" and so on.

In other ETL tools, this would be possible by using MOD math function but would like to know whether this can be possible other than "tMap" in Talend? Please advise or suggest.