Placing a maximum value from a table into a STORE name

[jagjivvt]

Hi

When using Store procedure is it possible to have  one of the field names as part of the file name?

Sample:

Load

Field1,

Field2,

Field3

from \\\xxxx.xls

store Sample into \\\\xxx.....Field3_.csv

thanks

Vijay

[swuehl]

Sure, just use the field name in the file name. I think I am missing your point.

[sunny_talwar]

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

[jagjivvt]

hi Sunny

Thanks, i need to get the max value from field3 to be within the name of the file.

thanks

Vijay    

[sunny_talwar · Accepted solution]

May be this:

Sample:

Load

Field1,

Field2,

Field3

from \\\xxxx.xls

Temp:

LOAD Max(Field3) as MaxValue

Resident Sample;

LET vMaxVal = Peek('MaxValue');

DROP Table Temp;

store Sample into \\\\xxx.....Field3_$(vMaxVal).csv

[jagjivvt]

Thanks a lot, much appreciated.

[sunny_talwar]

Not a problem

I am glad I was able to help.

Best,

Sunny