Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have the following question: I would like to load a formula and use it in my loading script. Is that possible? Please see attached file.
Thanks,
Oliver
Yep.
Information:
LOAD * INLINE [
Job, Machine
1, A
2, B
3, A
];
FormulaLoad:
LOAD * INLINE [
Formula
"if(Machine='A','New Machine',Machine)"
];
LET vFormula = peek('Formula');
Left join(Information)
Load *
,$(vFormula) as NewMachine
Resident Information;
drop table FormulaLoad;
Yep.
Information:
LOAD * INLINE [
Job, Machine
1, A
2, B
3, A
];
FormulaLoad:
LOAD * INLINE [
Formula
"if(Machine='A','New Machine',Machine)"
];
LET vFormula = peek('Formula');
Left join(Information)
Load *
,$(vFormula) as NewMachine
Resident Information;
drop table FormulaLoad;
That is exactly what I needed. Thanks,
Oliver