topic Talend join two files by column id and create a new entry in Talend Studio

Talend join two files by column id and create a new entry

Anonymous — Sat, 16 Nov 2024 07:57:35 GMT

Hi,

this is my first post here in talend community.

productsFile:

product_id	target
Maxplore_4G	ALL

discountsFile:

discount_id	product_id	target
Maxplore_4G_2_55000_A	Maxplore_4G	\|1\|2\|3\|4\|5\|6\|7\|8\|9\|10\|11\|12\|
Maxplore_4G_2_55000_B	Maxplore_4G	\|1\|2\|3\|4\|5\|6\|7\|8\|9\|10\|11\|12\|
Maxplore_4G_3_90000_Q	Maxplore_4G	\|1\|
Maxplore_4G_3_90000_R	Maxplore_4G	ALL

Expected Output

product_id	discount_id	target
Maxplore_4G		ALL
Maxplore_4G	Maxplore_4G_2_55000_A	\|1\|2\|3\|4\|5\|6\|7\|8\|9\|10\|11\|12\|
Maxplore_4G	Maxplore_4G_2_55000_B	\|1\|2\|3\|4\|5\|6\|7\|8\|9\|10\|11\|12\|
Maxplore_4G	Maxplore_4G_3_90000_Q	\|1\|
Maxplore_4G	Maxplore_4G_3_90000_R	ALL

Basically what i want is for each product id in productsFile join discountsFile on discountsFile and also create a new entry without discountId for every distinct productId in productsFile.

I was able to do the join using a regular tMap but i have no idea on how to create that empty discountId.

Thanks in advance

Re: Talend join two files by column id and create a new entry

vboppudi — Mon, 16 Jul 2018 22:20:50 GMT

HI Are you looking for the following output?

tMap used to join product and discount files to get only discounts available in product table and by using unite union the data product and discounts.

Regards,

Re: Talend join two files by column id and create a new entry

Anonymous — Mon, 16 Jul 2018 23:13:22 GMT

It's almost there

The flow should work based on productId from productsFile.

so for each productId in productsFile we need to go find a match in discountsFile , not the other way.

I managed to fix the issue by changing you solution