'How can we split a column with multiple values separated by "space" delimiter into multiple rows in Qlik using any logic

I have one requirements as below. Suppose I have a column with below values

rowno             Column

1                 MS Teams slack skype
2                 slack
3                 skype

I want to split the first row as below 

rowno          Column

1              MS Teams
1              slack
1              skype
2              slack
3              skype

How I can not use sub field function since it will split MS Teams to MS ,Teams. Instead can I use wildmatch? Please suggest how I can achieve this in Qlik Sense?

qliksense


Solution 1:[1]

I'd probably do it in 2 parts... first to replace the MS Teams value with MS_Teams and then do the subfield. You could add another part to get rid of the _ at the end.

Table:
    Load
    rowno,
    subfield(Column_clean,' ') as Column;
Load
    rowno,
    replace(Column,'MS Teams','MS_Teams') as Column_clean
from source;

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 x3ja

Related Questions