Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
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
Thank u So much for the Help 😄