Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi @Since 1995,
you can do the join in a tMap
Or try with tFuzzyMatch
Kind regards,
😷19.
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
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