topic Re: Help with concatenating values with loop and store in a variable in QlikView

Help with concatenating values with loop and store in a variable

sujit_nath — Wed, 25 Nov 2020 16:16:04 GMT

I need to loop from 1-20 (for example)

and take a variable such that value of the variable would be : Replace(Replace(Replace(Replace(Replace(.......... 20 times.

Could some one help me with this?

Re: Help with concatenating values with loop and store in a variable

vishsaggi — Wed, 04 Apr 2018 13:43:53 GMT

Can you share some sample data and what you are expecting to see? Why you need 20 Replace functions? Just wanted to understand?

Re: Help with concatenating values with loop and store in a variable

sujit_nath — Thu, 05 Apr 2018 05:15:45 GMT

Hi Vishwarath,

This would be in reference to a the ques posted:

How to exclude possible combinations of few keys?

If you see one of the answers there, this approach is suggested. So, wanted to take that with loop rather than manually writing all that.

Re: Help with concatenating values with loop and store in a variable

Anonymous — Thu, 05 Apr 2018 05:48:00 GMT

Hi,

Perhaps use a for loop with a peek function inside the loop

Re: Help with concatenating values with loop and store in a variable

tresB — Thu, 05 Apr 2018 06:48:20 GMT

You could try something like:

load * Inline [

Exclude

D

E

F

];

temp:

Load

Key,

Replace(Replace(Replace(If( IterNo()=1, Key,Peek('KeyNew')), FieldValue('Exclude', IterNo()),''), '[',''),']','') as KeyNew

While IterNo()<=FieldValueCount('Exclude');

Load * Inline "

Key

";

FinalExclusion:

Load Key as FinalExclude Resident temp where Len(KeyNew)=0;

NoConcatenate

Final:

Load Distinct Key Resident temp where not Exists(FinalExclude, Key);

Drop Table temp;

Re: Help with concatenating values with loop and store in a variable

sujit_nath — Thu, 05 Apr 2018 10:04:59 GMT

This is incredible!! That actually works and is a great solution in few LOC's.

Thanks a lot