topic Re: WildMatch in QlikView

WildMatch

himabinduch — Mon, 29 Feb 2016 05:55:33 GMT

Hi Friends,

in my data i have below 4 fields. some IRN NO have different different status in status des field. I want IRN NO which having the status as Principle Spare in Transit and Spare in Transit as separate field. and please find the sample data as attached.

IRN NO

CREATIONDATE

time

status des

Re: WildMatch

sunny_talwar — Mon, 29 Feb 2016 18:58:52 GMT

You want to only load those rows of data where INR NO has both status Principle Spare in Transit and Spare in Transit?

Re: WildMatch

kaushiknsolanki — Mon, 29 Feb 2016 18:59:51 GMT

Hi,

Try this.

Load *,if([Status Des] = 'Principal Spare in Progress',[IRN NO]) as [Principal Spare in Progress IRN NO],

if([Status Des] = 'Principal Spare in Transit',[IRN NO]) as [Principal Spare in TransitIRN NO]

From xyz;

Regards,

Kaushik Solanki

Re: WildMatch

jonas_rezende — Mon, 29 Feb 2016 21:05:46 GMT

Hi, hima bindu chadalawada.

The Wildmatch will help you find part of the word. Example:

Sample_data:

LOAD [IRN NO],

CREATIONDATE,

time,

[status des]

FROM

(ooxml, embedded labels, table is tharun)

Where

WildMatch([status des],'*Spare*') // Similar LIKE in SQL - [status des] like '%Spare%';

The result is:

The Match will help you find the word equal occourrence, one or other. Detail, It works like operator logic or. Example:

Sample_data:

LOAD [IRN NO],

CREATIONDATE,

time,

[status des]

FROM

(ooxml, embedded labels, table is tharun)

Where

match([status des],'Principle Spare in Transit','Spare in Transit');

a) [status des] = 'Principle Spare in Transit' or [status des] = 'Spare in Transit'.

b) Compairing to SQL, is command IN - [status des] IN ('Principle Spare in Transit','Spare in Transit')

The result is:

Hope this helps!

Re: WildMatch

himabinduch — Tue, 01 Mar 2016 08:32:12 GMT

Hi Jonas,

WildMatch is working thanks alot for u r help

Re: WildMatch

oknotsen — Tue, 01 Mar 2016 10:53:13 GMT

If your question is now answered, please flag the Correct Answer and possible Helpful Answers.

If not, please make clear what part of this question you still need help with .