Divide field values and invite them to a new field

[serder_uenlue]

Post translated by Qlik Community Team using Google Translate.

Only post in English on the Qlik Community, unless you are in a language specific forum.

----

Hallo Community,

I would like to know how I share field values from a field. Have the field "articles" loaded from an SQL database, now I would like to load the digits 1 to 26 and 100 from this field gladly in a new field with the field designation "additional positions".

Does anyone have a solution!

Best regards

[oknotsen]

Can you let me know which Qlik product you are using (QlikView or Qlik Sense) so I can move this topic to the correct forum?

Thank you.

[serder_uenlue]

I am using QlikView!

[Miguel_Angel_Baeyens]

If you are loading a position based field, then the way of doing it would be like

LOAD [@1:26] AS Field1,

[@100:100] AS Field2

FROM...