topic Re: Connecting on concatenated table in QlikView

Connecting on concatenated table

tomgrouwe — Sat, 16 Nov 2024 21:03:26 GMT

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?

Re: Connecting on concatenated table

dplr-rn — Fri, 12 Apr 2019 19:45:34 GMT

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

Re: Connecting on concatenated table

tomgrouwe — Thu, 18 Apr 2019 09:49:20 GMT

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.