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
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.
May be this:
LOAD Max(Field3) as MaxValue
LET vMaxVal = Peek('MaxValue');
DROP Table Temp;
store Sample into \\\\xxx.....Field3_$(vMaxVal).csv
Thanks a lot, much appreciated.
Not a problem
I am glad I was able to help.
Retrieving data ...