Picking values

[Anonymous]

Hi,

I have a file called receipt.qvd where I have the value Account. How can I choose to only include the following accounts:

3040, 3042, 4643, 4644, 4645, 4646, 4647, 4648, 4649.

Thanks!

[marcus_sommer]

Try it with:

...

where match(Account, 3040, 3042, 4643, 4644, 4645, 4646, 4647, 4648, 4649);

- Marcus

[kaushiknsolanki]

Hi,

You should use where condition, like below.

Load * from Receipt.qvd where match(Account,3040, 3042, 4643, 4644, 4645, 4646, 4647, 4648, 4649);

Regards,

Kaushik Solanki

[Anonymous]

That worked, thanks!