Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Link ship and bill address to one single address

Hey,

I have a table with orders and this includes shipaddress and billaddress. I have also a table Address.

now i want to connect the bill and shipaddress to the address in the Address table.

suggestions?

Kind Regards

1 Reply
Highlighted
Not applicable

Link ship and bill address to one single address

Something like this:


Temp:
load billaddress as Address
resident Orders;
load shipaddres as Address
resident Orders;
Addresses:
noconcatenate
load distinct Address
resident Temp;
drop table Temp;