Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am facing high reload time issue using wildmatch function in backend script in below :
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],
It is taking 1hr to reload and if i skip this wildmatch then it taked hardly 10 mins.
Can you please how I can fix this issue and what I can user instead of wildmatch in script
May be try to simplify it to this
Pick(WildMatch(Upper(Attribute), '*DATE*', '*PREM*') + 1, Text([Attribute Value]), Date(Floor([Attribute Value]), 'MM/DD/YYYY'), Text(Num([Attribute Value], '$#,##0.00')) ) as [Attribute Value],
I am not sure if the WildMatch is the problem or if is the problem.... I have suggested to remove the if and test.
Hi
It is still taking of time to reload.
Is this happening while loading from a qvd or any other source?
So, that is the issue.... create this new field before you create the qvd and then bring in this as a field and that should resolve your issue... The problem is that by creating this, you are breaking the optimized load. And this has nothing to do with this complicated calculation, just add 0 as Dummy and the optimized load will break