Data base and dictionary

[nicolearayav]

Hello guys,

Please help, I have a dictionary with the same information for two countries, see below:

QueueName	Department	Country
CSI	Sales	France
CSI	Sales	Germany

Then I have my database, I have separate files for each country:

SalesFrance.xlsx
SalesGermany.xlsx

The information in the files came like this:

For the SalesFrance.xlsx

QueueName	Calls
CSI	2

For the SalesGermany.xlsx

QueueName	Calls
CSI	4

So when I do the cross information on a table and I filter the country France, and QueueName: CSI
the table still show me the information for both countries, example:

QueueName	Calls
CSI	6

What can I do to differentiate the codes? because i already have the country filter, but doesnt work.

Please help! Thank you 

[Miguel_Angel_Baeyens · Accepted solution]

You can add a new field in the LOAD script, such as "Country" or "Source" where you store that information from the file name, if there are no better options.

Pseudocode should be:

FOR EACH vFile in FileList(C:\Folder\Files\*.xls)

LOAD
QueueName
Calls
FileName() as Source // '$(vFile)' could be use here as well
FROM vFile;

NEXT

- More on https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...
- Similar example on https://community.qlik.com/t5/QlikView-Scripting/Loading-xls-or-xlsx/m-p/264908