Script help

Mahamed_Qlik — Mon, 15 Apr 2019 12:10:21 GMT

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],

Re: Script help

marcus_sommer — Mon, 15 Apr 2019 13:30:42 GMT

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

topic Re: Script help in QlikView

Script help

Re: Script help