Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I wanted to know if there's any way to change the order of the variables showed in the panel
Do you know how could I do that?
Thank you!!!
The natural order will always be the order you created the variables in. They can however be sorted alphabetically as Julian suggests.
If you wanted to make the natural order different I guess you would have to delete the variables and re-create them. This is almost certainly overkill though.
Steve
Just clik on the header of each column and the list will be organized alphabetically asending or descending.
Sólo hacer clic en el encabezado de cada columna organizará la lista alfabéticamente, de forma ascendente o descendente
Saludos
The natural order will always be the order you created the variables in. They can however be sorted alphabetically as Julian suggests.
If you wanted to make the natural order different I guess you would have to delete the variables and re-create them. This is almost certainly overkill though.
Steve
it seems possible using an external files for variables with a sort column;
the natural order will be the order you set in the column of external excel files
Directory;
Tmp:
LOAD var as Variable,
exp as Expression,
sort
FROM
var.xlsx
(ooxml, embedded labels, table is Sheet1);
myTable:
NoConcatenate load * Resident Tmp order by sort;
For i = 0 to NoOfRows('myTable')-1
let var = peek('Variable', i, 'myTable');
let expr= peek('Expression', i, 'myTable');
set $(var) = $(expr);
Next i
let var=null();
let expr=null();
With that approach you would still need to delete all the variables first before re-applying them - which wouldn't be much fun.
I'm not sure why you have the temporary table in your example - could you not put the sort order on the Excel load?
I use spreadsheets for variables quite a bit - it's a good way of sharing the same values between apps. A new variable will always appear at the bottom of the list though - regardless of where you put it in the sort order on the table.
- Steve
Yes you have to delete all variables but if all variables are in excel is simple to recreate them, just load and the order is the order you define in sort column
I know isn't not a very good solution but is the only one I know and I sometimes (few) use
Regarding excel sort I think is possible to sort only resident