Using expression and functions when doing inline load

[#1]

Hi, I'm trying to use an expression in an inline load but having trouble with the right syntax.  Can someone please help?  Thx!

TableMinMax:

LOAD * Inline

[

tMinNum, tMaxNum

$(=Min(NumberA)),$(=Max(NumberA)),

$(=Min(NumberB), $(=Max(NumberB))

];

LOAD

  NumberA,

  NumberB

Resident NumberTable;

[Gysbert_Wassenaar]

It kinda looks like you want to use an inline load as a preceding load. If so, that cannot work. Try this:

TableMinMax:

LOAD

     min(NumberA) as tMinNum,

     max(NumberA) as tMaxNum,

Resident NumberTable;

CONCATENATE(TableMinMax)

LOAD

     min(NumberB) as tMinNum,

     max(NumberB) as tMaxNum,

Resident NumberTable;

[#3]

Yes, that's exactly what I'm trying to do.  Thank you!