Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chm-pixum
New Contributor

"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

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: "Concatenate" does not work as expected

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

9 Replies
pablolabbe
Valued Contributor II

Re: "Concatenate" does not work as expected

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

Re: "Concatenate" does not work as expected

Can you post your document log?

-Rob

MVP
MVP

Re: "Concatenate" does not work as expected

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
New Contributor

Re: "Concatenate" does not work as expected

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
New Contributor

Re: "Concatenate" does not work as expected

I tried, but there was the same wrong result.

Miguel solved it!

Thanks for your help!

Re: "Concatenate" does not work as expected

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

-Rob

MVP
MVP

Re: "Concatenate" does not work as expected

Rob,

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

Miguel

Not applicable

Re: "Concatenate" does not work as expected

Miguel,

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

Thanks!

Shawn

MVP
MVP

Re: "Concatenate" does not work as expected

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.

Community Browser