Using Qualify when concatenate tables in Load script

[musketeers]

Hi,

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:

Qualify*:

TestQualify:

Load

<my load statement from file -1>

Concatenate(TestQualify)

Load

<my load statement from file -2>

UnQualify*:

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.

Thanks

Rajneesh

[tresesco]

If you want them to be concatenated, having same file structure, they would get concatenated by default, Try simple load one after another like:

ConTable:

Load

          *

From <Source1>;

Load

          *

from <Source2>;

With all fields in common this would give you one resultant table called 'ConTable'.

[#3 · Accepted solution]

Hi Rajneesh,

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.

TestQualify:

Load

<my load statement from file -1>

Concatenate(TestQualify)

Load

<my load statement from file -2>

noconcantenate

Qualify *;

Data:

Load * reident TestQualify;

Drop table TesQualify;

Here you will have the data from both the files Qualified with the table name

[maxgro]

qualify *;

test:

load

  1 as f1,

  2 as f2

AutoGenerate 1;

unqualify *;

Concatenate (test)

load

  5 as test.f1,

  6 as test.f2,

  7 as test.f3

AutoGenerate 1;