Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
kkarlste
Creator
Creator

How do I get this done skript

Hi

This is a data

This is correct model

letterletterletter-numbernumbernumber

For example BP-100 or AFP-296

This is data   

100BP
100BR
102KAN
106HAO
109HAV
10CBA
10UAG
111ISS
AFO598
AFP296
AFT698
AFU291
AFX404
AGE590
AGM210
AGR941
AGT522
AGT555
AGT561
AGT563
AGT566
AGT923
AGT952
11 Replies
Miguel_Angel_Baeyens

I don't think there could be a more literal "step-by-step"!

Just as a note, with INLINE you can also use fields as with any other table, and no need to use a preceding LOAD since you can do it in the same line.

kkarlste
Creator
Creator
Author

Thanks that works good.

Br Kalle