Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jagjivvt
Contributor

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

Re: Placing a maximum value from a table into a STORE name

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

6 Replies
MVP
MVP

Re: Placing a maximum value from a table into a STORE name

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

Re: Placing a maximum value from a table into a STORE name

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
Contributor

Re: Placing a maximum value from a table into a STORE name

hi Sunny

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

thanks

Vijay    

Re: Placing a maximum value from a table into a STORE name

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
Contributor

Re: Placing a maximum value from a table into a STORE name

Thanks a lot, much appreciated.

Re: Placing a maximum value from a table into a STORE name

Not a problem

I am glad I was able to help.

Best,

Sunny

Community Browser