Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
;
next
exit script;
Thanks
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
Thank you
Please close this thread Qlik Community Tip: Marking Replies as Correct or Helpful
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
;
next
exit script;