I have couple of doubts.
1. How can i implement the below CASE logic inside tMap?
WHEN month = "Jan" THEN 1
WHEN month = "Feb" THEN 2
WHEN month = "Mar" THEN 3
WHEN month = "Apr" THEN 4
WHEN month = "May" THEN 5
WHEN month = "Jun" THEN 6
WHEN month = "Jul" THEN 7
WHEN month = "Aug" THEN 8
WHEN month = "Sep" THEN 9
WHEN month = "Oct" THEN 10
WHEN month = "Nov" THEN 11
WHEN month = "Dec" THEN 12
2. If my source input is excel and the target column is in PostgreSQL then how can i insert values to this target column using the worksheet name as per the CASE logic below-
WHEN data FROM PlannedPLC Worksheet THEN "PLC"
WHEN data FROM MDR Worksheet THEN "PLC"
WHEN data FROM DOSH Worksheet THEN "PLC"
WHEN data FROM PlannedGS Worksheet THEN "Gas"
Thanks in advance!
Look at the answer I gave here: https://community.talend.com/t5/Design-and-Development/Using-local-variable-in-tmap-expression-build...
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables