Loading specific data

[christophd]

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!

[Kushal_Chawda · Accepted solution]

[Text];

LOAD Kostenart,

            Sprache,

            Beschreibung

FROM

CSKU.xlsx

(ooxml, embedded labels, table is Tabelle1)

Where Exists (Kostenart)

and lower(Sprache)='de';

[tamilarasu]

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';

[christophd]

Thanks both!

I always tried

...Where Exists (Kostenart)and where (Sprache)='DE';

So the second "where" was wrong