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

How do I implement this mapping logic in tmap?

Anonymous — Sat, 16 Nov 2024 06:47:51 GMT

I am having a hard time understand what this mapping logic is talking about and what i need to do to implement it in tmap.

I am being asked to use the thiveinput and tmap componenets to first select the fields and then implement mapping logic in the tmap component. Any help would be greatly appreciated.

Re: How do I implement this mapping logic in tmap?

manodwhb — Tue, 22 Jan 2019 04:46:29 GMT

@idontknowany ,for all the fields it is same logic,in tmap ,in the output section enable expression filter and write below way.

row1.event_id.equlas("row2.event_id) && row1.event_activity_type_cd.equals("update_adress_phone_number")

Re: How do I implement this mapping logic in tmap?

ThWabi — Tue, 22 Jan 2019 10:25:05 GMT

Hi idontknowany,

I do not know Hive, but I understand your screenshot as having two files/tables ('agreement' and 'event') with certain columns (attributes).

These tables are joined on 'event_id' and activity_type must have a given value. So here is a suggestion of how to implement that in tMap:

Logic in tMap

Ajust the output columns and tMap join settings to your needs.

Best regards,

Thomas

Re: How do I implement this mapping logic in tmap?

dipanjan93 — Tue, 22 Jan 2019 16:45:50 GMT

You could use expression editor in the output side of tmap else, you could also mention it in the query itself in order to get the desired result set!