Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I'm having a scenario to deal with many to many.
Attched is the sample data.
I need to plot # sites at each location.
I can't explain more beacure It may confuse.
By seeing data you can understand.
Thanks..
There is not a good relationship in the data. Country is the only thing in common and the data doesn't match up.
eg AUSTRALIA
PHILIPPINES
Hi,
Please find the attached revised data.
I need bring site ID to the dimension sheet to get event type for site ID's.
Please help me I'm out of Ideas.
Thanks...
I cannot see the relationship between these tables to do that
Try reviewing the following Help link, you may be able to find what you need there to figure out how you need to proceed here:
Regards,
Brett
try using combination of both country and location. But seems like there are lot many mismatches.
Map_site:
mapping LOAD Distinct lower(trim(Country))&lower(trim(Location)) as Key,
[Site ID]
FROM
[Book1.xlsx]
(ooxml, embedded labels, table is [SIte ID]);
Data:
LOAD country,
location,
//lower(trim(country))&lower(trim(location)) as Key2,
applymap('Map_site',lower(trim(country))&lower(trim(location)),'NA') as [Site ID],
latitude,
longitude,
event_type
FROM
[Book1.xlsx]
(ooxml, embedded labels, table is DImension);