Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Christian,
Instead using load *, have you tried explicit declaring all fields from both tables ?
There is no rows for year 2013 ?
Kind Regards,
Can you post your document log?
-Rob
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
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
I tried, but there was the same wrong result.
Miguel solved it!
Thanks for your help!
But this is a bug, no? That you have to force an unoptimized load to get Concatenate to work?
-Rob
Rob,
It is and has been fixed, but not in this release.
Miguel
Miguel,
Is there a "bug" log anywhere so we could look there first?
Thanks!
Shawn
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.