topic Invert content of a variable in QlikView

Invert content of a variable

puttemans — Tue, 21 Apr 2015 13:00:17 GMT

Dear all,

I'm facing this issue where I really need a solution for.

I have a file containing an identifier (MORO-ID) and a route. This route is composed of a varying number of stationcodes, each time separated by a semicolon. For some of the MORO-ID's, I now need to invert the route. So given a route a;b;c;d;e;f;g this would need to become g;f;e;d;c;b;a

Could anyone give me a hint on how to tackle this?

(file attached)

Re: Invert content of a variable

jpenuliar — Tue, 21 Apr 2015 13:26:54 GMT

see below:

Reverse string

Re: Invert content of a variable

Anonymous — Tue, 21 Apr 2015 14:43:53 GMT

See the attached file,

Data:

Load

100000000- rowno() as Seqno

Where len(REV_ROUTE_TEMP)>0

;

LOAD [MORO_ID ] as MORO_ID,

ROUTE,

subfield(trim(ROUTE),';') as REV_ROUTE_TEMP

FROM

[MOBIB_ROUTE_2015.qvd]

(qvd);

Data2:

NoConcatenate

Load

MORO_ID,

';'&Concat(REV_ROUTE_TEMP,';',Seqno)&';' as REV_ROUTE

Resident Data

group by MORO_ID

;

drop table Data;

Re: Invert content of a variable

puttemans — Wed, 29 Apr 2015 12:57:13 GMT

Hello Amarbogam,

Thank you for your solution. To me, it is really impressing. In just 20 seconds, all lines are inverted !

Thanks a lot !!