Store information on Variables

[GLicks_DG]

Hi all,

Is there any way to store information from a given table into a variable?

For instance, I need to use the count of a given dimension in future calculations. So I was trying something like this:

Table:

Load Dim1, Dim2 from [a given file];

LET vCount = count(Dim1) resident Table;

Thank sin advance!

[marcus_malinow · Accepted solution]

Try this

Temp:

LOAD

count(Dim1) as Dim1Count

RESIDENT Table;

LET vCount = peek('Dim1Count',-1);

DROP TABLE Temp;

[GLicks_DG]

@marcus_malinow It worked perfectly. Thank you!

[marcus_malinow]

You're welcome, happy to help