Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
in our Company we started with Qlikview now and the only help is a book for developers
So hopefully you can help me a little bit...
I have a main data and want to load a second table now, but not the whole table.
My Syntax:
[Text];
LOAD Kostenart,
Sprache,
Beschreibung
FROM
CSKU.xlsx
(ooxml, embedded labels, table is Tabelle1)
Where Exists (Kostenart);
It is a table with translations for a lot of languages.
Is it possible to load only the data, where "Sprache" is filled with "DE"?
Thanks a lot!
[Text];
LOAD Kostenart,
Sprache,
Beschreibung
FROM
CSKU.xlsx
(ooxml, embedded labels, table is Tabelle1)
Where Exists (Kostenart)
and lower(Sprache)='de';
[Text];
LOAD Kostenart,
Sprache,
Beschreibung
FROM
CSKU.xlsx
(ooxml, embedded labels, table is Tabelle1)
Where Exists (Kostenart)
and lower(Sprache)='de';
Hi Christoph,
What you mean by second table.? Something like below!!!
[Text];
LOAD Kostenart,
Sprache,
Beschreibung
FROM
CSKU.xlsx
(ooxml, embedded labels, table is Tabelle1)
Where Sprache= 'DE';
Thanks both!
I always tried
...Where Exists (Kostenart)and where (Sprache)='DE';
So the second "where" was wrong