Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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