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: 
jagjivvt
Creator
Creator

Placing a maximum value from a table into a STORE name

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

6 Replies
swuehl
MVP
MVP

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
Creator
Creator
Author

hi Sunny

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

thanks

Vijay    

sunny_talwar

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
Creator
Creator
Author

Thanks a lot, much appreciated.

sunny_talwar

Not a problem

I am glad I was able to help.

Best,

Sunny