topic Re: 2 fields to be mapped to one in QlikView

2 fields to be mapped to one

vaibhav11 — Fri, 06 Apr 2018 05:00:10 GMT

i have 2 fields having similar values(ship to adress and bill to adress ) in Sales table .

i have to connect it with only one field that is adressID in adress table.. how can i achieve it.

Both shiptoadress and bill to adress have same kind of values that are all present in adressID

Re: 2 fields to be mapped to one

gerry_hdm — Fri, 06 Apr 2018 05:40:46 GMT

have you a example what du you want?

greetings gerold

Re: 2 fields to be mapped to one

petter — Fri, 06 Apr 2018 05:42:30 GMT

You have two options:

Create a table called AddressType with three fields: addressID.Sales, addressType,addressID. The first field you have to have in the Sales table too - that way you get a key shared between the Sales and AddressType tables. The lastfield in the AddressType table will have to be in the Address table so you get a key shared between the AddressType and Address tables. In the field addressType you will have only two possible values: 'ShipTo' or 'BillTo' which identify what kind of address row you have in the AddressType table.

The concept is similar to what Henric Cronström has descibed in his article about "Canonical Date". So in your case we could call this "Canonical Addresses". Look here: Canonical Date
Create two separate tables named ShipToAddresses and BillToAddresses and you have two separate ids for each of them.

Re: 2 fields to be mapped to one

gerry_hdm — Fri, 06 Apr 2018 05:45:39 GMT

You can duplicate you ID Field as a ID2 when you selcion the ship to adress and bill to adress )

are the values identical ship to adress and bill to adress ?

Re: 2 fields to be mapped to one

Anonymous — Fri, 06 Apr 2018 05:48:37 GMT

Hey,You can try ApplyMap() and merge them into one field

Re: 2 fields to be mapped to one

vaibhav11 — Fri, 06 Apr 2018 06:47:47 GMT

there are various other fields in adress table and also the sales table is having many rows, if i make them as two different tables , and concatenate them, they will result in double the rows. adress table has all values of adresses and is a primary key.

shiptoadress ID and billtoadressID may be same or different but all its values are present in adressID column in adress table

Re: 2 fields to be mapped to one

vaibhav11 — Fri, 06 Apr 2018 06:55:26 GMT

Re: 2 fields to be mapped to one

vaibhav11 — Fri, 06 Apr 2018 06:56:28 GMT

Re: 2 fields to be mapped to one

vaibhav11 — Fri, 06 Apr 2018 07:17:31 GMT

the scenario is a bit different here. The shipto address and billto address have IDs that are all present in AddressID field of the Address table.

I just want all the values (may be same or different) to be mapped to AddressID .There are some values presnt in shiptoadress which are not present in billtoaddress and vice versa