Storing Field value to Variable

[Anonymous]

Hi All,

I have a column named "ForecastFileName" which contains a text value for one row and remaining rows are null.

Now i would like to store that one text value to a variable.

Is there a better way than below? I have few more columns which need to be stored to variables, So if i use the following it will be repetitive code. suggestions are appreciated.

Temp:

load ForecastFileName

Resident Table1

where not isnull(ForecastFileName);

let v_RequiredName=Peek('ForecastFileName',0,Temp);

[Anonymous · Accepted solution]

For loop Solved the issue.