Assigning Column Value to a variable

Naushad07 — Tue, 30 Nov 2021 18:17:33 GMT

Hi,

I have a table with some IDs. I am looking to iterate these IDs one by one and pass it to an REST API URL.

[Table]:
LOAD
ID
FROM [Sample.qvd]
(qvd);

FOR Each a in FieldValueList('ID')
LOAD '$(a)' as ID1 AutoGenerate 1;

Let vID=FieldValue(ID1);

Let vURL=somevalue/$(vID)/somevalue;

But vID doesn't pick up any values from the Table. Any help is appreciated.

Re: Assigning Column Value to a variable

Naushad07 — Fri, 18 Jun 2021 09:06:51 GMT

I made it work.

I used Let vID='$(a)' instead