topic Re: Combining 2 Fields to 1 Field in QlikView

Combining 2 Fields to 1 Field

LGiles89 — Tue, 11 Feb 2020 16:29:37 GMT

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?

Re: Combining 2 Fields to 1 Field

sunny_talwar — Tue, 11 Feb 2020 16:46:20 GMT

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.

Re: Combining 2 Fields to 1 Field

LGiles89 — Wed, 12 Feb 2020 10:28:59 GMT

Thank you so much! That worked 🙂