Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this
Temp:
LOAD
count(Dim1) as Dim1Count
RESIDENT Table;
LET vCount = peek('Dim1Count',-1);
DROP TABLE Temp;
Try this
Temp:
LOAD
count(Dim1) as Dim1Count
RESIDENT Table;
LET vCount = peek('Dim1Count',-1);
DROP TABLE Temp;
@marcus_malinow It worked perfectly. Thank you!
You're welcome, happy to help