This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi All ,
In continuation to https://community.qlik.com/t5/New-to-Qlik-Sense/Loop-Match-Load-and-Store/m-p/1854116#M194562
Please let me know , what is wrong with below code . Its fetching 0 records around exists . LOOPDATA:LOAD * INLINE [SRCEMP1EMP4EMP7];
LET rowText = NoOfRows('LOOPDATA'); for i=1 to $(rowText) let text = FieldValue('SRC',$(i)); main:
LOAD * ,
'$(text)' as PNN Where Exists('$(text)',FILED2) ;
LOAD * INLINE [FIELD1, FILED2ID1, EMP1ID2, EMP1ID3, EMP1ID4, EMP4ID5, EMP1ID1, EMP3ID2, EMP1ID3, EMP3ID3, EMP4ID4, EMP7ID5, EMP6ID1, EMP7];
STORE main into location.............\tbl$(i).qvd ;
next i ;
Exists() uses a fieldname as parameter. You want to test for a value so instead do:
Where FILED2 = '$(text)' ;
View solution in original post
I was trying to achieve this , but it seems not working . Any alternate way ? Please suggest