File imported in random order

I am importing a .csv file into my list .The file got imported succesfully,but I see the records are not in the same order as in the .csv file. ex. The first record in the .csv file appears in the middle of the record set in the list.

Is there anyway , I can insist the records in my list are appearing in the same order as in my .csv file?

I have attached the screen shots of my .csv and the list .

Thanks

Regards

Prabakaran

Screenshot_2019-07-13_at_10_48569.png

Accepted answers

All comments

anirudh

Hi Prabakaran,

Are you importing into the sku list using combination of properties or code?

Is there any specific reason you want the list members to appear in the same order as the CSV file?

After uploading, you can use the sort function in Anaplan to force a particular order of appearance..

Regards,

Anirudh

pnataraj

Hi Anirudh

Thanks for the update.We have dashboards that are pulling the data from the sku config workbnench, and Business has a use case where they want to have the dashboard displaying the data in the same order that the .csv file has.

Hence, we want to have the records imported into workbench as it is in .csv file.

Thanks

Regards

Prabakaran

anirudh

Hi Prabakaran,

Please try deleting the whole list and re-uploading the file; ideally the list members must appear in the same order.

If that doesn't work, please try the following:

In the module where you want to specify the sort order, create a line item called sort dimensioned only by the sku config workbench list (remove all the other dimensions). Then specify 1,2,3 etc for each SKU in the same order as the csv file. Then use Anaplan's Sort function based on this line item and republish the module to the dashboard

Example list before:

Example after sorting (click on the 'Sort' line item and simply apply the Sort)

Hope this helps!

Regards,

Anirudh

anirudh

Hi Prabakaran,

Please try deleting the list and re-upload it. Ideally, it should be in the same order as the file.

If that doesn't work please try the following:

Create a new line item dimensioned with only sku config workbench (remove all other dimensions). Then fill this line item with sequential 1,2,3... etc in the same order as in the file. Then use Anaplan's Sort based on this line item

Before Sort:

After Sort based on the Sort line item above (Just click Sort, ignore settings and click OK)

Then just hide the Sort line item and republish the module to the dashboard

Let me know if this helps!

Regards,

Anirudh

Niranth

Hi @pnataraj

Please delete the list and try re-uploading it. If this doesn't work use the Sort function in the module (Sort function should be based on a line item as per the .csv file). And republish this to the dashboard.

Quick Links

Can you help?

Unanswered questions

Anaplan Matillion Integration
I have a requirement to extract last 90 days data from an Anaplan model through Matillion. I wanted to know is there any API which I can use to achieve the same? I have taken a look at the (Integration APIs) Bulk API as well as Transactional API and none of them has a relevant query parameter which I can use to apply the…
How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
How to create identical child items for multiple parents
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…