Assigning Column Value to a variable

[Naushad07]

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.

[Naushad07 · Accepted solution]

I made it work.

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