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.
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.
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:
Load *, 'Europe' as Region
Load *, 'Asia' as Region
See also here for a more comprehensive solution to load files from a directory (and its subdirs).
View solution in original post