classify if text includes

Tue, 11 Oct 2011 13:19:12 GMT

Hi,

does anyone have any idea how to select lines based on a part of text a particula field includes?

e.g.

I have the following account names:

WIP manual postings

Commerc inventories -goods in transit exchange rat

Good In Transit - Transfer

Com.inv.goods received/invoice received adjustm.

Com.inv.goods in transit intercomp.del.goods rec.

Com.inv.goods in transit-goods shipped to 3rd part

Com.inv.goods in transit-interc.dlv.goods invoic.

Com.inv.GIT dlv.goods invoic. Own wh deliv

How to simply select these lines that have 'GIT' or 'goods in transit' or 'Goods In Transit' and classify them as [GIT accounts]?

Thanks for any tip.

swuehl — Tue, 11 Oct 2011 13:23:47 GMT

try

Load

if(wildmatch([account names],'*GIT*','*Goods in Transit*','*goods in transit*'),1,0) as [GIT accounts],

...

from ...;

Hope this helps,

Stefan

Tue, 11 Oct 2011 13:30:30 GMT

Works for me. Thank you:)

topic classify if text includes in QlikView