topic Access to table data in script in Water Cooler

Access to table data in script

Thu, 17 May 2012 09:50:40 GMT

Hi all!

I'm trying to read a table from a QVD file and then use a row of that table in the same script. I need it in order to read parameters and store them in variables. The sample code I'm working on is the following:

TABLA:

LOAD * INLINE [

A,B,C

1,2,3

4,5,6

7,8,9

];

LET Five=MinString({<A={4}>} B);

Is there any way to achieve this?

Thanks in advance.

Access to table data in script

Miguel_Angel_Baeyens — Thu, 17 May 2012 09:58:50 GMT

Hi,

I'm not sure on what you want to achieve, exactly. But you cannot use set analysis in the script. However, RangeSum (and the rest of the range functions), Peek and Previous as in this thread, this thread and this other thread among many others you can search for should work.

Hope that helps.

Miguel

Access to table data in script

flipside — Thu, 17 May 2012 11:00:10 GMT

LET Five = Lookup('B','A', 4, 'TABLA');

Works if you are confident the lookup value is unique in the referenced column, or you can accept the first matched value.

flipside

Access to table data in script

Thu, 17 May 2012 11:35:22 GMT

Thanks, Lookup solved the problem. I was trying to load a string from a qvd and then use that string to load other tables.

Btw, why does Lookup work in this situation while MinString doesn't? Just for the sake of curiosity.

Access to table data in script

flipside — Thu, 17 May 2012 12:49:30 GMT

There are two MinString functions, one for use in the load script and one for use in the expressions in the charts.

To use it in the script, you would need something like ...

TABLB:
LOAD MINSTRING(B) AS Minstring resident TABLA;

LET MinStr = Peek('Minstring',0,'TABLB');

flipside