Creating region for each table/file

[#1]

Hello everyone.

I'm all new to this so there is probably an easy solution to my question.

At the moment I have two log files which I load into two Qlikview-tables.

Each log file represents a specific region but there is no column for region.

Since the columns are the same for each table I would like to filter the data depending on the region.

For example:

tableA(Region = "Europe") | tableB(Region = "Asia")

So how can I setup my two tables to represent a different region?

If there is some example out there feel free to point me to it.

Thank you.

[Gysbert_Wassenaar · Accepted solution]

Load the log data from all the source files into one table and add a region field to be able to see where the data came from. Simplified something like this:

Logs:

Load *, 'Europe' as Region

from ...europelog...;

Load *, 'Asia' as Region

from ...asialog...;

See also here for a more comprehensive solution to load files from a directory (and its subdirs).