Loading conditional information from two different files.

[Richard3]

I need to load the information in my app in the following way, I have an excel file with the income values ​​per month, but if there is a month that I take the value of that month but in another excel file that I also have configured to load.
That's possible?

[henrikalmen]

It is a bit difficult to know what your case is without examples, but if you have data for one month in one file and data for another month in another file, you could use the prefix concatenate when loading the second table. There are other possibilities as well, but it would be good with some more information.

[rwunderlich · Accepted solution]

You can use the "Where not exists(Monthfield)" clause in your load to use the Month value from one value and not the other. The order in which you load matters. 

Data:
Load Monthfield, Value, ...
From excel2 ...;

Concatenate (Data)
Load Monthfield, Value, ...
From excel1 ...
Where not exists(Monthfield);

See https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Richard3]

Sorry, I've been trying and varying the values ​​but it always shows me only the values ​​of the table that I'm concatenating:

Concatenate (budget)
Load
bg_id1 as budget_id,
bg_date1 as budget_date,
bg_amount1 as budget_amount
Resident Data1

I send the example of what I am doing.

budget:
Load
bg_id as budget_id,
bg_date as budget_date,
bg_amount as budget_amount
Resident Data;
Concatenate (budget)
Load
bg_id1 as budget_id,
bg_date1 as budget_date,
bg_amount1 as budget_amount
Resident Data1
Where not exists(budget_amount ,bg_amount1);

Thanks for your support.