How do I implement this mapping logic in tmap?

Five Stars

How do I implement this mapping logic in tmap?

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.

 

Screen Shot 2019-01-21 at 5.04.09 PM.png

Forteen Stars

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

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Seven Stars

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

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:


tmap_mapping_logic.pngLogic in tMap

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

 

Best regards,

 

Thomas

 

Six Stars

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

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!

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download