Discussion Board for collaboration related to QlikView App Development.
I have two files which I need to load in one table. The file structure is same.
So I am creating two load statements with concatenate key word.
I am using Qualify * also in the beginning.
The table name I have given is TestQualify.
It is like this:
<my load statement from file -1>
<my load statement from file -2>
Now the issue is in the second load statement. The Qualify* function is not qualifying the second file fields with the name TestQualify.
Instead of TestQualify it is using the second file name as qualifier.
Is there any way we can force qlikview to qualify the second file fields with TestQualify name.
Go to Solution.
Iam not sure why you are qualifyig in the beginning and unqualifyinf when the file structure is same.
you can do the below to have the qualifier.
Load * reident TestQualify;
Drop table TesQualify;
Here you will have the data from both the files Qualified with the table name
View solution in original post
If you want them to be concatenated, having same file structure, they would get concatenated by default, Try simple load one after another like:
With all fields in common this would give you one resultant table called 'ConTable'.
1 as f1,
2 as f2
5 as test.f1,
6 as test.f2,
7 as test.f3