Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Manuel174102
Creator
Creator

How to only keep data from a column that has a particular structure?

Hello, I have the following data. For my analisis I only need the AB numbers, they all have the same structure which is AB0*****. How can I only keep them?

 

Greetings

 

What I have

Number
AB028394
AB057493
AN48394
KA75984
AN47398

 

What I need:

 

Number
AB028394
AB857493
Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

Load Number

From YourTable

Where WildMatch(Number,'AB*');

View solution in original post

2 Replies
Or
MVP
MVP

Load Number

From YourTable

Where WildMatch(Number,'AB*');

Manuel174102
Creator
Creator
Author

thanks. it worked