topic Add value from multiple rows to once cell in Discussions

Add value from multiple rows to once cell

jearls11 — Fri, 09 Jun 2023 16:04:38 GMT

Hi folks,

I want to insert multiple values into one cell. I have manually done it in the screen grab so i want the value from row 1,2,3 to be joined together and added to 3 rows.
Not sure how to complete this, do i need more identifiers so it can join the code. sorry I cant share the dataset due to IP reasons but below is a snippet

Re: Add value from multiple rows to once cell

KarenC — Tue, 13 Dec 2022 00:29:10 GMT

You can use a formula....

If contains(Process RC 2 , "RC1") then concatenate("[", char(:blasmultiplier), "," , lag(-1, char(:blasmultiplier)), lag(-2, char(:blasmultiplier)) )

else lag(1, Column 59)

That is a rough rendition....hopefully enough for you to figure it out...