Hi,
I have a list of data values that I need to concatenate.
use case: Below table contains the products purchased by a customer and I want to see what all products he was holding before purchasing a new product. Similarly, the same goes with other customers The column 'desired result' is the expected output.
Customer id | Date | Order_num | Product | desired result |
1 | 1-Jan-18 | 1 | xx | |
1 | 2-Jan-18 | 2 | yy | xx |
1 | 3-Jan-18 | 3 | zz | yy,xx |
1 | 4-Jan-18 | 4 | ww | zz,yy,xx |
1 | 5-Jan-18 | 5 | ss | ww,zz,yy,xx |
I have an idea that this can be achieved by Multi-row formula but I am stuck in between. Kindly help.
Thanks
Solved! Go to Solution.
Hi @Tamanna_Patil ,
I think, you can solve it using the Multi-Row Formula tool. I've attached a sample workflow.
Let me know if it works for you.
Best,
Roland
Hey Roland,
Thanks a lot for your help. This is working exactly as expected.