Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
HI @ashmitp869
Try like subfield function like below
Load SubField(EpisodeKey , '-',2) as EpisodeKey,
cxxx,
yyyt
FROM [\\xxx\yyy\sample.qvd](qvd);
HI @ashmitp869
Try like subfield function like below
Load SubField(EpisodeKey , '-',2) as EpisodeKey,
cxxx,
yyyt
FROM [\\xxx\yyy\sample.qvd](qvd);