Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a data set like bellow mentioned -
And I want the Output as below-
Can you please help me in getting this sorted.
Regards,
Rakesh Paul
Try this:
Table:
LOAD ID,
SubField(No, ':') as No
FROM
[https://community.qlik.com/thread/237520]
(html, codepage is 1252, embedded labels, table is @1);