Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Storing Field value to Variable

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

For loop Solved the issue.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

For loop Solved the issue.