topic Re: Wildmatch in excel in QlikView

Wildmatch in excel

shanky1907 — Fri, 19 Sep 2014 10:03:05 GMT

Hi,

I want to use wildmatch like function in excel for a specific column.

Please reply if you have any idea.

Thanks in advance.

Re: Wildmatch in excel

amit_saini — Fri, 19 Sep 2014 10:09:32 GMT

Shashank,

Just a small example below:

Suppose I'm having excel sheet with column name City and I want to change city names for example Punjab as P1 , Haryana than below is Syntax .

Syntax:

LOAD Products,

City,

pick( WildMatch(City,'*Punjab*','*Haryana*','*Delhi*'),'P1','P2','P3')

as Data

FROM

Prcatice.xlsx

(ooxml, embedded labels, table is Sheet3);

Re: Wildmatch in excel

Gysbert_Wassenaar — Fri, 19 Sep 2014 10:11:23 GMT

Questions about Excel functions are better asked somewhere else, but perhaps the example here helps: www.mrexcel.com/forum/excel-questions/524460-wildcard-within-match-function.html