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.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
