Qlikview script

[ashmitp869]

Hi All,

How to exclude the first 5 position of any field and load in qlik script. My requirement is to pick after "-" ?

The data in table looks like below

TMP_table:

load EpisodeKey,
cxxx, 
yyyt
FROM [\\xxx\yyy\sample.qvd](qvd);

[MayilVahanan · Accepted solution]

HI @ashmitp869 

Try like subfield function like below

Load SubField(EpisodeKey , '-',2) as EpisodeKey, 

cxxx, 
yyyt
FROM [\\xxx\yyy\sample.qvd](qvd);