Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Bringing selective entry or codes from a huge list of data

Hi All,

I have a huge list of products that are exported and imported country wise. I want to bring only a selected products into my qlikview data base. Please advise. The data is always available in a bunch. You can't segregate it while downloading it. The products are mentioned in codes. For eg - Clothing - 6110113.Footwear - 640110 etc. Like this there are more than thousand's of codes. From which i only need around 50 -60 product codes. I tried putting all the 50 codes that i require in an excel sheet and upload it to my data base but it didnt work.

Can anybody help me on this?

Thanks

Ani

3 Replies
whiteline
Honored Contributor II

Re: Bringing selective entry or codes from a huge list of data

Hi.

Create a table with list of codes that you want to load.

It can be an inline LOAD or LOAD from some external fiel (Excel).

Let's assume the field is named 'CodesToLoad'.

Then append a string to your data LOAD statement:

LOAD

     Code,

     ... (some other fields that you load)

FROM ... (your source)

WHERE exists('CodesToLoad', Code);

Not applicable

Re: Bringing selective entry or codes from a huge list of data

Hi Whiteline,

Many thanks for the revert. Could you please tell me how to go about it if there are multiple sources instead of one?

Thanks

Anirban

whiteline
Honored Contributor II

Re: Bringing selective entry or codes from a huge list of data

Hi.

If you mean multiple source files (or http links and so on) you could use FOR or FOREACH statement.

There is an example in help.

Community Browser