Combining 2 Fields to 1 Field

[LGiles89]

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?

[sunny_talwar · Accepted solution]

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.

[LGiles89]

Thank you so much! That worked 🙂