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.
It still doesn't work, it says Invalid expression
Can you share your script for where you are trying this out?
I've got the GROUP BY
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
Where's the option to mark your request as correct?
I think this was put as a discussion rather than a question. For discussion you cannot have correct answers.
Cheers, i'll make sure it's a question next time.
Wow, where clause in IF condition....
Your syntax is wrong, try what Sunny suggested you
I got women problems and trying to work at the same time, brain not functioning properly. Thanks for all the help.
Put your Women Problems threads here, after posting I assure your brain will work properly
I've upset her for telling her some home truths and now i'm getting the cold shoulder lol
Sorry guys, i had one extra field that wasn't on the GROUP BY
Sorry for being a pain, ill award you guys points
Thats what we expects not like this:
If we start arguing their is no end
Retrieving data ...