Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
First time posting on here, so apologies if i do not explain very well.
I am doing some work with transport data with a Collection and Delivery Locations. Each Combination of 1st Location+2nd Location has a set rate. I need to be able to link the data so that i can put a rate against each of the transport moves.
What i would like is:
Collection & Delivery as LocationKey,
Delivery & Collection as LocationKey
Data Set 2
From & To as LocationKey
How can I set up my data to allow 2 Keys to be created using the same name so it links to the single key created in my second data set?
You will have to concatenate to do this
Table:
LOAD Collection & Delivery as LocationKey,
...
FROM...;
Concatenate (Table)
LOAD Delivery & Collection as LocationKey,
...
FROM...;
You can also create a Link table to do this so that now all data has to be duplicated.
You will have to concatenate to do this
Table:
LOAD Collection & Delivery as LocationKey,
...
FROM...;
Concatenate (Table)
LOAD Delivery & Collection as LocationKey,
...
FROM...;
You can also create a Link table to do this so that now all data has to be duplicated.
Thank you so much! That worked 🙂