Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi, hima bindu chadalawada.
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:
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!
You want to only load those rows of data where INR NO has both status Principle Spare in Transit and Spare in Transit?
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
Hi, hima bindu chadalawada.
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:
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!
Hi Jonas,
WildMatch is working thanks alot for u r help
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 .