Discussion Board for collaboration related to QlikView App Development.
Can any one please help me in below requirement.
In ID field I have the records like below.
ID Output ID
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
subfield(ID, '_' ,1) as New
View solution in original post
keepchar(ID,'0123456789') as NewID;
load * inline[