Bringing selective entry or codes from a huge list of data

[#1]

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

[whiteline]

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

[#3]

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]

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.