This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a filed where the filed has ID and Text as below.
I want data as like below
Thanks it worked out for me, also can you help me on the below link which is quite similar.
View solution in original post
You can try something like this:
PurgeChar function removes unnecessary symbols in your case is % and space.
Mid and Right functions allows to select correct symbols
LOAD ID, Mid(PurgeChar(Text, '% '), 4, 4) AS Text1, Right(PurgeChar(Text, '% '), 4) AS Text2;LOAD * Inline[ID, TextIMO67, %%AAA%% %%A123%% %%AAA%% %%A456%%];
If it's possible please mark correct answers as "solutions".
Also, I don't see the link, please send it again.