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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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