Implement logic with tMap

[Anonymous]

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

[manodwhb]

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

Product_Name and RGB fields?

[Anonymous]

Hello Manohar,

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

Thanks,

Nag

[manodwhb]

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

[Anonymous]

@manodwhb, This is what to define the Logic. 

[Anonymous]

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

[Anonymous]

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.