how to Transpose the column?

[Akina0929]

Hi

I  have  table that consist two columns

             field1        field2

               1              A,B,C

               2              D,E,F

From above table I need output like below

              field1        field2

               1              A

               1              B

               1              C

               2              D

                2             E

                 2            F

Thanking you,

[Anonymous · Accepted solution]

     SubField(field2, ',') as field2

[sunny_talwar]

These is a similar example available in help:

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm‌

[Akina0929]

Thank you,

  got it

[Anonymous]

please close the query (discussion ) by clicking on "answered "

[Akina0929]

Hi,

    Where is that option "answered",sorry I didn't find.

Thanking you,

[#7]

Click on ur question once and see the options