topic Delete Duplicated words in QlikView

Delete Duplicated words

Ayoub — Mon, 15 Apr 2019 13:25:04 GMT

Hello community ..

in an application i'm working on we need to delete duplicated words in sentences like : Qlik Qlik View we should get Qlik View

i worked with the code bellow but it didn't give me the result i'm looking for . i should look for all the repeated words in the same sentences and delete them.

Re: Delete Duplicated words

marcus_sommer — Mon, 15 Apr 2019 14:46:06 GMT

I think I wouldn't use a sub-routine with/within outside-loops else normal loads with inside-loops and an aggregation - something in this way:

t1:
load *, -(StringPart = previous(StringPart)) as Flag, rowno() as RowNo;
load String, subfield(String, ' ') as StringPart from Source;

t2:
load concat(StringPart, ' ', RowNo) resident t1 where Flag = 0;

- Marcus

Re: Delete Duplicated words

Ayoub — Mon, 15 Apr 2019 15:26:19 GMT

i liked ur answer @marcus_sommer and as i'm new at qlikview .. How could i get the result i'm looking for for exemple : ayub atr

Re: Delete Duplicated words

marcus_sommer — Tue, 16 Apr 2019 07:15:22 GMT

Did you try my suggestion? Just apply it step by step and look what happens to understand the logic. After it you could extend it to your real requirement which probably contained any ID and maybe need the one or another adjustment.

- Marcus

Re: Delete Duplicated words

Ayoub — Tue, 16 Apr 2019 16:54:04 GMT

Thank u So much for the Help 😄