Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
himabinduch
Contributor

WildMatch

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 NOCREATIONDATEtimestatus des
1 Solution

Accepted Solutions
Highlighted
jonas_rezende
Valued Contributor

Re: WildMatch

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!

View solution in original post

5 Replies
Highlighted

Re: WildMatch

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: WildMatch

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
jonas_rezende
Valued Contributor

Re: WildMatch

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!

View solution in original post

Highlighted
himabinduch
Contributor

Re: WildMatch

Hi Jonas,

WildMatch  is working thanks alot for u r help

Highlighted
oknotsen
Honored Contributor III

Re: WildMatch

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 .

May you live in interesting times!