Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.