Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Subfield() help

Hi Experts,

Can any one please help me in below requirement.

In ID field I have the records like below.

ID                                                                                  Output ID

75963865                                                                      75963865 

987596386                                                                    987596386

789456123_04586_Transfer_Time                               789456123

789456123_0WR_Transfer_Time                             



From the above id I have to remove the data after  '_ ' need to get the Output ID.


Please help me on this.


Thanks in advance

1 Solution

Accepted Solutions
Chanty4u
Champion III
Champion III

try this

subfield(ID, '_' ,1)    as New

View solution in original post

2 Replies
Chanty4u
Champion III
Champion III

load*

,

keepchar(ID,'0123456789')  as NewID;

load * inline[

ID

.....

.......

];

Chanty4u
Champion III
Champion III

try this

subfield(ID, '_' ,1)    as New

View solution in original post