Eliminate disabled number - best efficient way

[Anonymous]

Hi Guys,

I have a question regarding data modelling in QV.

I have data source with numbers in rows as primary keys : 10001, 10002....n.

And i have additionally list in Excel with numbers (and whole rows for it) which should be not showed in the end report.

What is the best soultion for it?

I can load data from Excel, and do for example applymap and use where clause.

Or maybe better should I use join? 

Please advise,

Best wishes,

Jacek Antek

[Anonymous]

Yes I understand now, but I would never do it like that.

But to be  honest I don't know what is faster...