Hi Anaplanner,
I'm import data like this, but i want to sort data based on color before im import to another
after import the data will be like this
can anaplan provide like that?
Thanks,
Panji
@Panji,
I would like to know few things before try and answer this,
May I know the reason for sort and import?
Based on what factor you are sorting there (categorized as color)?
Are you ignoring the non-colored rows?
It would be great if you can help us with this.
Sandeep
Hi @sandeep_bk ,
the reason is i want to make a journal, and the color just a note that data(color) will be import to create journal, and the sort will be order like a picture 2.
Hi @Panji,
My question here is, based on what method of sorting(or logic) you arrived at picture 2?
Is this import data file keeps changing or is it a static import you do once?
If you need functionality like a sort and a filter to arrive at picture 2, we need to know the method behind your sorting and color-coding so that we can have some logic in Anaplan to do so.
if you are simply selecting/marking a few rows in the file based on your assumption, then you will have to do the same in Anaplan to achieve so ( Select the required rows and save as view )
Let us know if you need any further help
Hi @Panji,If you want Anaplan to color automatically then I agree with @sandeep_bk it would e helpful to know what's the logic for coloring.If you are asking if Anaplan can sort by color the answer is there is no native capability to do so however it's very easy to accomplish. If that's your goal let me know and I'll explain one way to do that.
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
