Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Why isn't this where MATCH working? in load script
Many thanks in advance
sum(if(WHERE match ([PRODUCT],'xxx','yyy','zzzz'),Value)) AS NEWTEST,
Try it without WHERE
Sum(If(Match(PRODUCT, 'xxx', 'yyy', 'zzzz'), Value)) as NEWTEST
UPDATE: You might need a Group By statement in case you have other fields in this particular load.
Wow, where clause in IF condition....
Your syntax is wrong, try what Sunny suggested you
It still doesn't work, it says Invalid expression
It still doesn't work, it says Invalid expression
I've got the GROUP BY
Thanks
Can you share your script for where you are trying this out?
Sorry guys, i had one extra field that wasn't on the GROUP BY
Sorry for being a pain, ill award you guys points
Where's the option to mark your request as correct?
FYI....If you are using aggregate function at script level then you should Group by.....
Expression suggested by Sunny was right, the only issue was that you did not share the the full script code with Group By