Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chm-pixum
Contributor II
Contributor II

"Concatenate" does not work as expected

Hey Qlik-guys (and ofcourse -girls),

although I'm working with QlikView in Germany as a Developer and User since five years, this is my first posting in this wonderful community.

Yesterday I downloaded Qlik Sense for my private use, so I can test it at home before I will test it for our existing data models in our company.

My private data model (about Formula 1) contains separate crosstables from Excel like this:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Ergebnisse:

Crosstable(Typ, Tipp, 2)

Load

     Rennen,

     '2014' as YearRace,

     [2],

     [3],

     [4]

From Datasource_2014.xlsx

(ooxml, embedded labels, table is QV4);

Store Ergebnisse into Ergebnisse_2014;

drop table Ergebnisse;

Ergebnisse:

Crosstable(Typ, Tipp, 2)

Load

     Rennen,

     '2013' as YearRace,

     [2],

     [3],

     [4]

From Datasource_2013.xlsx

(ooxml, embedded labels, table is QV4);

Store Ergebnisse into Ergebnisse_2013;

drop table Ergebnisse;

>>>>>>>>>>>>>>>>>>>>>>>>>>>>

These steps I have for six years and this works in Sense without any problems.

But in the next step I want to combine these separate Year-Tables to only one Complete Table:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Kombination:

Load

      *

From Ergebnisse_2014.qvd (qvd);

concatenate

Load

      *

From Ergebnisse_2013.qvd (qvd);

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

In the first QVD are 260 rows and after concatenating with the second QVD there are only the same 260 rows and no row from the 2013 file has been concatenated.

Is this a bug or where is my mistake?

Thanks for your help - I already love Dashboard Designing with Qlik Sense, it's much more comfortable as in AJAX.

Best regards

Christian Moke

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi Christian,

Try as follows:

Kombination:

Load

      *

From Ergebnisse_2014.qvd (qvd) WHERE 1=1;

concatenate

Load

      *

From Ergebnisse_2013.qvd (qvd) WHERE 1=1;

With the WHERE clause after the FROM.

Miguel

View solution in original post

9 Replies
pablolabbe
Luminary Alumni
Luminary Alumni

Hi Christian,

  Instead using load *, have you tried explicit declaring all fields from both tables ?


  There is no rows for year 2013 ?


Kind Regards,


Pablo Labbe

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you post your document log?

-Rob

Miguel_Angel_Baeyens

Hi Christian,

Try as follows:

Kombination:

Load

      *

From Ergebnisse_2014.qvd (qvd) WHERE 1=1;

concatenate

Load

      *

From Ergebnisse_2013.qvd (qvd) WHERE 1=1;

With the WHERE clause after the FROM.

Miguel

chm-pixum
Contributor II
Contributor II
Author

Hi Miguel,

this was the solution, adding the "where 1=1"-clause and it works!

9 seconds in Qlik Sense vs. 12 seconds in QlikView 11.2

chm-pixum
Contributor II
Contributor II
Author

I tried, but there was the same wrong result.

Miguel solved it!

Thanks for your help!

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

But this is a bug, no? That you have to force an unoptimized load to get Concatenate to work?

-Rob

Miguel_Angel_Baeyens

Rob,

It is and has been fixed, but not in this release.

Miguel

Not applicable

Miguel,

Is there a "bug" log anywhere so we could look there first?

Thanks!

Shawn

Miguel_Angel_Baeyens

I'm sure there is, but internal for R&D. Public, not that I know of, since it is not yet the full version -that will become available later on this year.