Trim last Part of text field put it as a new field

[Anonymous]

Team,

Field	comment
1	Working on support_ALM1234,      Working on Read rate_SLA345
2	support process_IN4353, Billed 100%_ALM234
3	Working on issues_ALM2357, working on Support_IN56452

from the table i want to result should be  trim the value after '_'  value as a new field.

For example:

     desired output should be like following below:

field	comment	Ticket ID
1	Working on support	ALM1234
1	Working on Read rate	SLA345
2	support process	IN4353
2	Billed 100%	ALM234

Please suggest.

[sunny_talwar · Accepted solution]

Try this:

Table:

LOAD SubField(Newcomment, '_', 1) as Comment,

  SubField(Newcomment, '_', 2) as [Ticket ID],

  Field;

LOAD Trim(SubField(comment, ',')) as Newcomment,

  Field;

LOAD Field,

    comment

FROM

[https://community.qlik.com/thread/250332]

(html, codepage is 1252, embedded labels, table is @1);

[MK_QSL]

Data:

Load

  Field,

  Trim(SubField(comment,'_',1)) as comment,

  Trim(SubField(comment,'_',2)) as [Ticket ID]

;

LOAD Field,

     SubField(comment,',') as comment

FROM

[https://community.qlik.com/thread/250332]

(html, codepage is 1252, embedded labels, table is @1);

[MK_QSL]

You already replied !!!! LOL

[sunny_talwar]

[Anonymous]

thank you sunny