Using a WHERE clause on a row

[#1]

Hello,

I have an issue with a spreadsheet which has columns headed M/V and M/R. When this is put into QV it reads these columns as M/V1, M/V2 and M/R1, M/R2 etc. Is there a where clause that can search this particular row and only load the columns which start with M/V?

Thank you,

Paul

[disqr_rm]

Not one clause that I am aware of but little trick, with power of what QlikView can do, this can be surely done.

See enclosed.

[#3]

Hi Rakesh,

Thanks for your reply. The example that you attached looks good with a text file. However when i change this to an Excel file it cannot find the @1 field. Are Excel rows named something in QlikView, and can these be made a varible?

Thanks, Paul

[disqr_rm]

Here you go. Hope it helps.