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: 
capriconuser
Creator
Creator

Numeric character data in qlikview

I have this kind of data

 

Notes
-
B-3-I11 - Issue 
B-3-I12 -  Windows update
BI1-I190   internet speed issue
BI1-I191  Handed over 
backup server 
Installation  laptops
M Presentation
Meet Meti
Work on  documentation 

 

 

now I want only those data which start from B and have numeric characters.. i want both conditions in one field.. and I want this in script .. in load statement  like

Load

ID,

Name,

here I want condition ,

........

from table1

 

not in where statement.. .

Labels (3)
5 Replies
capriconuser
Creator
Creator
Author

any help 

Anil_Babu_Samineni

Do you mean this?

Load

ID,

Name,

If(WildMatch(FieldName, 'B*'), FieldName) as FiledName_OnlyB

........

from table1

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
capriconuser
Creator
Creator
Author

yes I got data which starts from B .. but i want also which data have numeric characters.. like some data I have

B32-12-Test

so in this condition, I want only B32-12 but currently I got as B32-12-Test @Anil_Babu_Samineni 

 

Anil_Babu_Samineni

In your example I see that character  "I"

 Also please post sample inline and provide us output

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Lisa_P
Employee
Employee

I'm not sure if this will always work, but I have used multiple preceding loads to first only include those descriptions that had a capital B, then removed the characters after the space.

Notes:
Load
LEft(Description, FindOneOf(Description, ' ')) as Code;
Load
If(FindOneOf(Description, 'B'), Description, null()) as Description;
Load * Inline [
Description
B-3-I11 - Issue
B-3-I12 - Windows update
BI1-I190 internet speed issue
BI1-I191 Handed over
backup server
Installation laptops
M Presentation
Meet Meti
Work on documentation
];

Lisa_P_0-1611726513165.png