Discussion Board for collaboration related to QlikView App Development.
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
You have two options:
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 ?
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
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