JOIN COLLECT NOT WORKING COULD ANYONE HELP
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
Answers
-
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))
-
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
😊
-
Double check that you have selected the correct ranges first.
How exactly are each of the different ranges filled in?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!