How to do Outer join in Talend

[since_1995]

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

[Covid19]

Hi @Since 1995​,

you can do the join in a tMap

Or try with tFuzzyMatch 

Kind regards,

😷19.

[since_1995]

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 · Accepted solution]

Hi

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

Regards

Shong