Well in my good guess, because I don't really have the right answer right now. is that there has been multiple files before also. But I think I have to ask if that is the case. But how that can mess around with the Load & join ? Or should that be a for each function there in place and when there has been one file it just loaded the one. And if there has been many files, it just has loaded the first one of them?
So now with the "double load" - we get all the files loaded to the table. I think I now understand a little bit better
When you have multiple files, they auto-concatenate to form a single table (assuming all of them have the same set of fields). But if you are joining, the auto-concatenate action might not kick in. It tries to join the first excel file and once it does that, the other once won't join at all because of the left join.
So I think it is work checking if there was only one file before and now you have multiple files.
Also keep an eye on your other join
@3 AS prod_id,
@4 AS prod_name
(txt, utf8, no labels, delimiter is \x1, no quotes);
Check how many files are within this location
Yeah I think the problem has been with that it has just loaded one file first that has data. If QlikView has that kinda logic, that it skips the files that has no data even if there is multiple files on the location. Really have to check the files now
Thanks for all the help for now already, helped my thought process too!