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!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog