Match limitation

[hugmarcel]

Hi

I experience that the match(a, b, c, d, ...) function does not work when the list of compare elements (b, c, d) get's too long. Is there a match-limitation, saying the number of arguments can only be < 255 or similar?

If yes, how to overcome this?

Thank you - Marcel

[d_pranskus]

Hi

In what context you are using this function?

Cheers

Darius

[hugmarcel]

In a pivot diagram.

I have to fields A (1000 values) and B (1000 values) and I want to check matches of values against each other. The fields shall not be linked in the data model.

[d_pranskus]

Could you send an example?

[hugmarcel]

we found one of the compare strings contained a quote (')... This made the function call fail.

So no argument limitation... 🙂

Sorry for the inconveniences & thx for the help!

Marcel

[d_pranskus · Accepted solution]

Hi

Actually quote (') problem could occur in any context.

Draius