Could you please tell me whether a dynamic calculation is possible?
Imagine I have a table like this (in script editor):
Load * INLINE [
Var1, Var2, Var3,Var4,Var5
LOAD (Var1 + Var2 +Var3) as [sum all var]
This simple situation becomes complex when
Table1 has 500 columns from Var1 up to Var500
Table1 has different column names, so Var1 = Thickness, Var2 = Spreadability
The sum of Var1..,.Var500 varies depending on the data structure and user selection and as a consequence not all columns will be concerned in computation e.g. (Var1 + Var2) as [sum all var], (Var12 + Var13 + Var273 + Var303) as [sum all var] etc. a LOT of possibilities.
As you may see, this is an example of dynamic environment. I suppose that this can be solved with a macro program but I’m not very sure.