How do I implement this mapping logic in tmap?

[Anonymous]

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.

[manodwhb]

@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")

[ThWabi]

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

[dipanjan93]

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!