Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],
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