Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
himabinduch
Creator
Creator

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
jonas_rezende
Specialist
Specialist

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
sunny_talwar

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jonas_rezende
Specialist
Specialist

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!

himabinduch
Creator
Creator
Author

Hi Jonas,

WildMatch  is working thanks alot for u r help

oknotsen
Master III
Master III

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!