Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
eddyvargas
Contributor II
Contributor II

Create Master Item by RPA using excel file

I Have an excel file with formulas (KPI) to create variables

_vMedidas:
LOAD
    Variavel,
    Formula
FROM [lib://$(vFolder)/Medidas.xlsx]
(ooxml, embedded labels, table is KPI);
 
FOR i=0 to NoOfRows('_vMedidas')-1
_vVariavel = Peek('Variavel',i);
_vFormula = Replace(Peek('Formula',i),'$','!@#%');
    
    "$(_vVariavel)"=Replace('$(_vFormula)','!@#%',Chr(36));
Next
 
How can I create Metric Master Item automatically? using RPA (robot), Python or another solution?
 
Thanks
Labels (1)
  • SaaS

0 Replies