topic Re: Numeric character data in qlikview in QlikView

Numeric character data in qlikview

capriconuser — Fri, 15 Nov 2024 23:20:16 GMT

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.. .

Re: Numeric character data in qlikview

capriconuser — Tue, 12 Jan 2021 19:40:22 GMT

any help

Re: Numeric character data in qlikview

Anil_Babu_Samineni — Tue, 12 Jan 2021 20:16:34 GMT

Do you mean this?

Load

ID,

Name,

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

........

from table1

Re: Numeric character data in qlikview

capriconuser — Wed, 13 Jan 2021 05:22:02 GMT

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

Re: Numeric character data in qlikview

Anil_Babu_Samineni — Wed, 13 Jan 2021 08:01:38 GMT

In your example I see that character "I"

Also please post sample inline and provide us output

Re: Numeric character data in qlikview

Lisa_P — Wed, 27 Jan 2021 05:48:49 GMT

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
];