topic Re: Implementing Case Statement in tmap in Talend Studio

Implementing Case Statement in tmap

dipanjan93 — Mon, 08 Oct 2018 14:28:05 GMT

Hi All,

I have couple of doubts.

1. How can i implement the below CASE logic inside tMap?

CASE
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-

CASE
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!

Best Regards,

Dipanjan

Re: Implementing Case Statement in tmap

Anonymous — Mon, 08 Oct 2018 15:24:33 GMT

Look at the answer I gave here: https://community.talend.com/t5/Design-and-Development/Using-local-variable-in-tmap-expression-builder/m-p/136652#M85008

Re: Implementing Case Statement in tmap

dipanjan93 — Mon, 08 Oct 2018 15:59:04 GMT

Hi @rhall,

Many Thanks for the prompt response.
This way I was able to solve my 1st issue. Anything regarding the second issue?

Regards,
Dipanjan

Re: Implementing Case Statement in tmap

Anonymous — Mon, 08 Oct 2018 22:47:27 GMT

You can use a global variable for that. This variable...
((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET"))
..... will tell your tMap what the current sheet is. Remember that the key is the name of your component. Basically you will need to change the number.