Connecting on concatenated table

[tomgrouwe]

Dear readers,

I need some help with the following.

I'm making a dashboard for managing our complaints. One part of the complaints is registered in our ERP system and one part is registered in an Excel file. Because both files look a lot like eachother, I'm concatenating both tables to eachother. However this leaves me with the following.

In the Excel file, we register the order on which the complaint is registered. In our ERP system the order isn't available in the complaint table. I need to make a connection to the orderaction table to add the order to the complaint. However, this creates a syntatic key because order is already in the complaint table from the excel file.

I rather don't wanna use a Mapping load because there is er more valuable information in the orderaction table.

What is the best solution?

[dplr-rn]

Hard to understand the problem clearly.
Maybe give a sample of data in ERP and the excel and describe problem again

[tomgrouwe · Accepted solution]

Solved the problem by changing the load order.

First perfomed a left join from the orderaction table on the ERP complaints. After that, concatenated the Excel file.

Works fine now.