Qlikview script

ashmitp869 — Wed, 21 Apr 2021 00:39:49 GMT

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);

Re: Qlikview script

MayilVahanan — Wed, 21 Apr 2021 02:58:32 GMT

Try like subfield function like below

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

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