Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

Script help

Below script is taking very long time to reload about 1 hour.

Please help to modify it to reduce reload time

 

 

Fact:

LOAD

if(wildmatch(Attribute, '*DATE*') or wildmatch(Attribute, '*date*') or wildmatch(Attribute, '*Date*'),
date(floor([Attribute Value]),'MM/DD/YYYY'),
if(wildmatch(Attribute, '*prem*') or wildmatch(Attribute, '*PREM*') or wildmatch(Attribute, '*Prem*'),
text(num([Attribute Value],'$#,##0.00')),
text([Attribute Value]))) as [Attribute Value],
if(len(num([Attribute Value],'###,###,###,###,###'))>0,[Attribute],null()) as [Attribute Num],

1 Reply
marcus_sommer

Your snippet of the load could be optimized but I doubt that this alone will have a very big effect on the run-times unless it breaks an optimized load. Nevertheless try:

alt(pick(wildmatch(upper(Attribute), '*DATE*','*PREM*'),
    date(floor([Attribute Value]),'MM/DD/YYYY'), num([Attribute Value],'$#,##0.00')),
    text([Attribute Value])) as [Attribute Value],
num([Attribute Value],'###,###,###,###,###') as [Attribute Num],

- Marcus