topic Re: For each - get a second value associated in QlikView

For each - get a second value associated

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

Hi everybody,

I have the following code. I would like to get the value of ce.archive in my For Loop.

How do I do that ?

CONCATENATE(filesToLoad)

load * inline

[

ce.archive, ce.fileList

'N', cpm.xlsm'

'O', 'ghdfsfds.xlsm'

'O', 'skfds.xlsm'

'N', 'liac.xlsm'

]

;

For Each nomfic in FieldValueList('ce.fileList')

tresB — Mon, 26 Mar 2018 10:25:13 GMT

Have you tried like?

For Each nomfic in FieldValueList('ce.fileList')

<your statement>

Next nomfic;

Anonymous — Mon, 26 Mar 2018 11:08:34 GMT

Hi Tresesco,

Yes. I've got the whole loop already. What I want, is get the first value of the inline table ce.archive in the loop.

sasiparupudi1 — Mon, 26 Mar 2018 11:25:26 GMT

may be just

Let xx=Peek('ce.archive',0,'T1');

sasiparupudi1 — Mon, 26 Mar 2018 11:28:11 GMT

or Let xy=FieldValue('ce.archive',1);

sasiparupudi1 — Mon, 26 Mar 2018 12:21:04 GMT

for each vField in FieldValueList('ce.fileList')

Let xx1='$(vField)';

Next;

Anonymous — Mon, 26 Mar 2018 14:33:03 GMT

Thanks Sasidhar, the second formula did not work, I got only null in my variable, but the first one was ok!

Have a good day!