Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning,
In a set analysis i want to list every record that don't match the condition, right column and left column being compared with the operator in the center column.
Can you help me ?
I'm not quite sure what do you want to achieve but I think it's not possible with set analysis because it's designed to evaluate the conditions on a column-level and not on a record-level. This means you would need an if-loop approach - whereby you couldn't simply add: col1 & col2 & col3 to get a calculation else this would be regarded as a string-concatenation. To get this evaluated within the UI you will need some more efforts maybe with pick(match()) constructs which is rather not very performant and surely not want do you intent.
IMO much better would be you perform this task within the script per evaluate() within a boolean flag-field which you could then use within the set analysis or as direct selection from a listbox.
- Marcus
Thank you for your answer, I will do it within the script the way you suggest. I've been stucked into trying to do it through the UI for one day with no result.