topic Re: Placing a maximum value from a table into a STORE name in QlikView

Placing a maximum value from a table into a STORE name

jagjivvt — Fri, 16 Oct 2015 15:05:16 GMT

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

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

swuehl — Fri, 16 Oct 2015 15:06:50 GMT

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

sunny_talwar — Fri, 16 Oct 2015 15:07:23 GMT

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

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

jagjivvt — Fri, 16 Oct 2015 15:09:44 GMT

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

sunny_talwar — Fri, 16 Oct 2015 15:11:29 GMT

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

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

jagjivvt — Fri, 16 Oct 2015 15:17:45 GMT

Thanks a lot, much appreciated.

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

sunny_talwar — Fri, 16 Oct 2015 15:18:05 GMT

Not a problem

I am glad I was able to help.

Best,

Sunny