JOIN COLLECT NOT WORKING COULD ANYONE HELP

seagent

Im trying to pull out a column after checking two criteria with join collect but not seeing any value, see below:

=JOIN(COLLECT({TEST2 Range 3}, {TEST2 Range 2}, [SALES ORDER]@row, {TEST2 Range 1}, [LINE-NO]@row))

FROM

Could anyone in SC look into this?

Thanks

Brett Smith

Hi Seagent,

In your COLLECT Function you haven't defined the criteria for the ranges you are assessing agains. I assume you want to see where:

{TEST2 Range 2}, =[SALES ORDER]@row, and

{TEST2 Range 1}, =[LINE-NO]@row)

So add in the equals signs for the criterion.

Then don't forget your delimiter in the Join function - is it a SPACE - " " , a Return - CHAR(10) etc

So, formula becomes...

=JOIN(COLLECT({TEST2 Range 3}, {TEST2 Range 2}, =[SALES ORDER]@row, {TEST2 Range 1}, =[LINE-NO]@row), CHAR(10))