Forum Discussion
Create list based on multiple columns
Naturally, that would happen, if you unpivot.
The reason, I'm asking, is that there is no intuitive way to slice the original table like you are asking for unless you create all the possible combinations of the 3 columns. That can be done in 2 ways (as I see it). Either unpivot or create all the combinations with a concatenate function (which, I think, is a very clumsy method). Either way, your database will grow in size. Unfortunately, I'm not familiar with any convenient way to slice like you are asking for.
Hi Martin,
Thank you for all your help. Though not the outcome I hoped for at least now I know there are no alternate solutions.
KR,
Sander
Hi Martin,
Appreciate the help!
I can manage a list based on 1 column :). I want to create a list based on multiple columns (see screenshot). I want to manually create a list of values from different columns.
For example in 1 flat list:
- North from colum Profit Center lvl1
- A and B from colum Profit Center lvl2
- 1, 2 and 3 B from colum Profit Center lvl3
Alright, I think I understand now. One quick question before I move on to a solution:
Is it necessary for "Profit Center lvl1", "Profit Center lvl2" and "Profit Center lvl3" to be seperate columns?
I guess not per se, but if I would unpivot them it would increase my database size of course
Naturally, that would happen, if you unpivot.
The reason, I'm asking, is that there is no intuitive way to slice the original table like you are asking for unless you create all the possible combinations of the 3 columns. That can be done in 2 ways (as I see it). Either unpivot or create all the combinations with a concatenate function (which, I think, is a very clumsy method). Either way, your database will grow in size. Unfortunately, I'm not familiar with any convenient way to slice like you are asking for.
Hi Martin,
Thank you for all your help. Though not the outcome I hoped for at least now I know there are no alternate solutions.
KR,
Sander