Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
For loop Solved the issue.
For loop Solved the issue.