Hi there, I need to get a very specific order to my Export to Tabular Singlular Columns. Right now I cannot seem to control the order of columns that comes out. Is this possible to do? Thanks in advance for your help.
Solved! Go to Solution.
|Product List||Customer List|
|Product A||Customer X||11||21||31|
|Product A||Customer Y||12||22||32|
|Product B||Customer X||13||23||33|
|Product B||Customer Y||14||24||34|
|Customer List||Product List|
|Customer X||Product A||11||21||31|
|Customer X||Product B||13||23||33|
|Customer Y||Product A||12||22||32|
|Customer Y||Product B||14||24||34|
I figured out the way Anaplan generates the order of Singular Column exports. Columns are exported left to right in order they appear from top to bottom in your general lists. So a way to control the export columns is to go to your general lists and rearrange them on how you want the export to be.
This is severly flawed. It's too easy and necessary to rearrange your lists logically, and if you have multiple developers in Anaplan, lists can constantly be rearranged by anyone. "Oh that makes sense to move"
I also found that I cannot re-order subset of lists; it doesn't change when I changed the order of the (parent) lists.