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))

seagent

Hi Brett,

Still its not showing up any value. Know that the logic is right but there is some little thing that could be causing an issue. Anyways thanks for offering a hand. Cheers

😊

Paul Newcome

Double check that you have selected the correct ranges first.

How exactly are each of the different ranges filled in?