How do I implement this logic in tmap?

Anonymous — Tue, 11 Dec 2018 22:33:09 GMT

CASE WHEN WMS_NAME_ADDR_TYPE_1_00 = 3 THEN TRIM(WMS_CITY_STATE_1_00) + " " + TRIM(WMS_NA_ZIP_CODE_1_00) ELSE WMS_NAME_ADDRESS_1_00

I have tables named WMS_NAME_ADDR_TYPE_1_00

WMS_CITY_STATE_1_00

WMS_NA_ZIP_CODE_1_00

WMS_NAME_ADDRESS_1_00

For now I have it as a straight map since I have no idea how to implement this logic:

I have the logic changed to tmap logic:

WMS_NAME_ADDRESS_TYPE_1_00==3?TRIM(WMS_CITY_STATE_1_01)+ " " + TRIM(WMS_NA_ZIP_CODE_1_00): WMS_NAME_ADDRESS_1_00

Did I convert the logic correctly, and where exactly do I put this logic since it's using multiple tables and I have a straight map?

Re: How do I implement this logic in tmap?

Anonymous — Wed, 12 Dec 2018 04:28:11 GMT

Hi,

This looks fine. Since you are doing concatenation operation, I would suggest the null values for WMS_CITY_STATE_1_00 and WMS_NA_ZIP_CODE_1_00 as empty string (using interim Var variables in tMap) before doing concatenation. Else you would get null value in output even if one of the variable is having null.

Warm Regards,

Nikhil Thampi

topic How do I implement this logic in tmap? in Talend Studio

How do I implement this logic in tmap?

Re: How do I implement this logic in tmap?