topic Load formula and use it while loading??? in QlikView

Load formula and use it while loading???

Fri, 28 May 2010 17:22:02 GMT

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

johnw — Fri, 28 May 2010 20:07:34 GMT

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;

Fri, 28 May 2010 21:33:44 GMT

That is exactly what I needed. Thanks,

Oliver