topic Using Qualify when concatenate tables in Load script in QlikView

Using Qualify when concatenate tables in Load script

musketeers — Wed, 15 Oct 2014 11:26:45 GMT

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

Concatenate(TestQualify)

Load

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

Re: Using Qualify when concatenate tables in Load script

tresB — Wed, 15 Oct 2014 11:43:01 GMT

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'.

Re: Using Qualify when concatenate tables in Load script

Wed, 15 Oct 2014 11:51:59 GMT

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

Concatenate(TestQualify)

Load

noconcantenate

Qualify *;

Data:

Load * reident TestQualify;

Drop table TesQualify;

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

Re: Using Qualify when concatenate tables in Load script

maxgro — Wed, 15 Oct 2014 11:56:21 GMT

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;