topic Re: Concatenate with Qualify in QlikView

Concatenate with Qualify

jmonroe918 — Wed, 15 Jan 2014 00:41:16 GMT

I am trying to append datasets into one table using Concatenate (they two queries in an MS Access database). I have pasted a jpg of the code and the resulting table. All of the fields are preceded with "temp_Complaints-1". I only want "Complaints".

What am I doint wrong in the code?

Thanks.

Jeff

Re: Concatenate with Qualify

Anonymous — Wed, 15 Jan 2014 01:59:18 GMT

Hi Jeff,

Name the table in your final load. The values will then be qualified as Complaints.Category, Complaints.CloseDate etc

Complaints:

LOAD *

resident temp_Complaints;

Re: Concatenate with Qualify

jagan — Wed, 15 Jan 2014 02:47:27 GMT

Hi,

Give the table name for the Load statement

Complaints:

LOAD *

resident temp_Complaints;

Regards,

Jagan.

Re: Concatenate with Qualify

Wed, 15 Jan 2014 04:25:59 GMT

Try like below:

temp_Complaints:

LOAD * ;

SQL SELECT * FROM 'qryComplaints_up';

Concatenate (temp_Complaints)

LOAD * ;

SQL SELECT * FROM 'qryComplaints_PCR' ;

QUALIFY * ;

Complaints:

Noconcatenate

LOAD * Resident temp_Complaints ;

UNQUALIFY * ;

Re: Concatenate with Qualify

kiranmanoharrode — Wed, 15 Jan 2014 05:32:40 GMT

Dear Jeffrey,

There Must be a Table Name in Line no. 26 (Table:). It will definately solve your problem.

Regards

Kiran Rode

+91 897 69 77 897

Re: Concatenate with Qualify

Wed, 15 Jan 2014 06:24:39 GMT

Hi,

since you have loaded temp_Complaints table and agina trying to load from same table you are getting temp_Complaints-1 as name . As kiran suggested place a table name before load statement it may solve your problem or

Instead of loading from resident table for this purpose is good so place a table name and qualify * at line number 1 and use a join to join these two table if necessary.

Regards,

Abhishek

Re: Concatenate with Qualify

jmonroe918 — Sun, 19 Jan 2014 21:34:36 GMT

Steve:

That did it. Thanks a lot.

Jeff

Re: Concatenate with Qualify

Anonymous — Wed, 14 Jan 2015 08:59:16 GMT

Just a +1 to using CONCATENATE and QUALIFY. And a warning to all QV newbies who do not yet understand that QV is a completely different animal. This may help you avoid the pain of 'what-am-I-doing-wrong' situations.

I had two tables in different SQL servers. Both were named were named Invoices and had the same column structure. I needed to load the data from these two tables into one table (like in SQL UNION ALL).

The problem was that I had QUALIFY *; in the script, and I did not pay much attention to it.

So when I was trying to concatenate the two tables, the fields of the first table had the prefix Invoices, while the fields from the second table showed up with prefix Invoices-1.

When I removed the QUALIFY *; concatenation worked like a charm.

Bottom line: watch out for QUALIFY *; when you do CONCATENATE.