Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@ris.tan ,need more details on ,how to get
Product_Name and RGB fields?
Hello Manohar,
Thanks for your message. Product_Name and RGBW are constants and need to load as Default.
Thanks,
Nag
@ris.tan , how you will define the constant for the particular record is Red or Green or Blue or White ?
@manodwhb, This is what to define the Logic.
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
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.