For each - get a second value associated

[Anonymous]

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')

[tresesco]

Have you tried like?

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

    <your statement>

Next nomfic;

[Anonymous]

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]

may be just

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

[sasiparupudi1]

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

[sasiparupudi1]

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

Let xx1='$(vField)';

Next;

[Anonymous]

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!