topic Re: Concatenation During Loop in QlikView

Concatenation During Loop

detmawin — Wed, 25 Oct 2017 06:49:12 GMT

I am trying to concatenation the following inside of the looping script:

original:

load * INLINE [

Field1, Attribute, Value

A, xx, 1034,

A, yy, 4076

A, zz, 34

B, xx, 2345

B, yy, 243

];

LET NumRows=NoOfRows('original');

FOR i=0 to $(NumRows)-1;

LET vBox=Peek('Attribute',$(i),original);

Concatenate

Data:

Load

if(Attribute ='$(vBox)',dual('Y',1),dual('N',0)) as '$(vBox)'

Resident original

;

exit script;

Thanks

Re: Concatenation During Loop

Anil_Babu_Samineni — Wed, 25 Oct 2017 06:54:47 GMT

Just try this?

Mai Cox wrote:

I am trying to concatenation the following inside of the looping script:

original:

load * INLINE [

Field1, Attribute, Value

A, xx, 1034,

A, yy, 4076

A, zz, 34

B, xx, 2345

B, yy, 243

];

LET NumRows=NoOfRows('original');

FOR i=0 to $(NumRows)-1;

LET vBox=Peek('Attribute',$(i),original);

Concatenate

Data:

Load

Field1, Value,

if(Attribute ='$(vBox)',dual('Y',1),dual('N',0)) as '$(vBox)'

Resident original

;

next

exit script;

Thanks

Re: Concatenation During Loop

detmawin — Wed, 25 Oct 2017 10:57:01 GMT

Thank you

Re: Concatenation During Loop

Anil_Babu_Samineni — Wed, 25 Oct 2017 11:07:04 GMT

Please close this thread Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Concatenation During Loop

its_anandrjs — Wed, 25 Oct 2017 11:34:06 GMT

Hi, This way you forget para thesis on the peek function. Peek('Attribute',$(i),'original');

original:

load * INLINE [

Field1, Attribute, Value

A, xx, 1034,

A, yy, 4076

A, zz, 34

B, xx, 2345

B, yy, 243

];

LET NumRows=NoOfRows('original');

FOR i=0 to $(NumRows)-1;

LET vBox=Peek('Attribute',$(i),'original');

Concatenate

Data:

Load

Field1,Value,

if(Attribute ='$(vBox)',dual('Y',1),dual('N',0)) as '$(vBox)'

Resident original

;

exit script;