Discussion Board for collaboration on QlikView Scripting.
When using Store procedure is it possible to have one of the field names as part of the file name?
store Sample into \\\\xxx.....Field3_.csv
Go to Solution.
May be this:
LOAD Max(Field3) as MaxValue
LET vMaxVal = Peek('MaxValue');
DROP Table Temp;
store Sample into \\\\xxx.....Field3_$(vMaxVal).csv
Sure, just use the field name in the file name. I think I am missing your point.
Are you looking for maximum value within a field (max value within Field3)? or are you looking for max field name among the three fields (Field1, Field2, Field3)?
Thanks, i need to get the max value from field3 to be within the name of the file.
Thanks a lot, much appreciated.
Not a problem
I am glad I was able to help.