Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
musketeers
Contributor

Using Qualify when concatenate tables in Load script

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Using Qualify when concatenate tables in Load script

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

View solution in original post

3 Replies
MVP
MVP

Re: Using Qualify when concatenate tables in Load script

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

Not applicable

Re: Using Qualify when concatenate tables in Load script

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

View solution in original post

MVP
MVP

Re: Using Qualify when concatenate tables in Load script

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;