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: 
salto
Specialist II
Specialist II

"Expand" field in several records

Hello,

In the load script, from a table like this;

Topic_ID1Header 2
1#Blue; #Green
2#White
3#Red; #Green; #White

I need to build a table like this:

Topic IDKeyword
1Blue
1Green
2White
3Red
3Green
3White

How can this be achieved? Many thanks in advance!

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

3 Replies
jerem1234
Specialist II
Specialist II

try something like:

purgechar(trim(subfield([1Header 2], ';')), '#')

Hope this helps!

jerem1234
Specialist II
Specialist II

Find attached.

salto
Specialist II
Specialist II
Author

Just perfect... thank you!