Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load formula and use it while loading???

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

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

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;

View solution in original post

2 Replies
johnw
Champion III
Champion III

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;

Not applicable
Author

That is exactly what I needed. Thanks,

Oliver