topic Re: How to do Outer join in Talend in Talend Studio

How to do Outer join in Talend

since_1995 — Fri, 15 Nov 2024 22:46:24 GMT

Hello,

I have location id , lat and long -- considering it as origin

and also customer id with lat and long

considering it as

destination.

now i have to use the distance matrix api and find the distance from each origin address to each destination addresses.

i don't have any common id between these two, how can i do a outer join in talend

InfoCraft — Fri, 01 Jul 2022 19:43:13 GMT

Hi @Since 1995,

you can do the join in a tMap

Or try with tFuzzyMatch

Kind regards,

😷19.

since_1995 — Tue, 26 Jul 2022 12:44:40 GMT

This doesnt seems to be working because i do not have any common key id's to match the origin and destination

Sorry for the wrong tittle, the requirement is to do a cross join

location id , lat and long -- considering it as origin

customer id , lat and long --considering it as destination

I want one origin to join with all the destination

suppose if i have 3 origin and 5 destination, the total count should be 3*5=15

Anonymous — Thu, 28 Jul 2022 04:42:10 GMT

Don't set any join key, it will output 3*5=15 rows if you have 3 origin data and 5 destination.

Regards

Shong