Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Sivarapu250
Contributor II
Contributor II

How to split the single filed into 2 fields.

Dear Guys,

I have  one filed (No delimiter in that field). I need split that into two fields.  Like

Ex:  Filed1:

       S1ETM

        S1STM

        S2EMT

        S3EMT

        S4EMT

        S2END

etc..

I need output Like (LAST 3 RECODS)

Time:

       ETM

       STM

       EMT

        EMT

        EMT

        END

 

 Kindly help.

     

Labels (1)
1 Reply
derekjones
Creator III
Creator III

right(Filed1,3) as Time