Find the address(current,permanent and work) of the each customer when the order was placed.

[sudheersakamuri]

Dear Experts,

Hope all of you doing great.

I have a customer order data and customer address history data (sample data attached).

Now, I want to get the address of the customer at the time of each order and for each address type.

As shown in the below SS, customer placed order 3781732 on 24/06/2009 8:29:06 AM and we want to get customer's current, permanent and work address codes when he placed this order.

If customer address changed multiple times in a same day then we have to consider the max(ADDRESS_CODE) for that Address Type.

Expected Output:

Kindly help me to achieve this.

Please find the attached qvf file.

[sudheersakamuri]

Dear Community,

I missed to upload sample data files.

Please find the attachments.