This content has been marked as final.
Show 4 replies
-
1. Re: Combine multiple order rows to 1
Zhouyi ZhangJan 16, 2019 4:59 AM (in response to willem.brachel.0)
Hi, Willem
Not quite sure whether you would like a hard code for cross items or dynamically, and also how to determine which category is the main product. but below is some idea of how to populate the data as cross join.
use inner join your data to itself with key 1=1 as shown below
And the view should be something like this
Hope this helps
ZZ
-
2. Re: Combine multiple order rows to 1
albert wong Jan 16, 2019 5:01 AM (in response to willem.brachel.0)Hi Willem,
Can you post an Excel example of what your end result should look like?
-
3. Re: Combine multiple order rows to 1
willem.brachel.0 Jan 16, 2019 6:34 AM (in response to Zhouyi Zhang)Hi ZZ and Albert,
Actually, this is almost exactly what I would like to achieve. I did write it down a bit messy, I am sorry.
What I would like to achieve: that the Category column will be transferred to rows, see attached a example of what I would like to achieve.
-
testcrosssell.xlsx 9.9 KB
-
-
4. Re: Combine multiple order rows to 1
Zhouyi ZhangJan 17, 2019 4:12 AM (in response to willem.brachel.0)