Contributor

File imported in random order

Hi

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

 

 

5 REPLIES 5
Certified Master Anaplanner

Re: File imported in random order

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

Contributor

Re: File imported in random order

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

Certified Master Anaplanner

Re: File imported in random order

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:

image.png

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

 

image.png

Hope this helps!

 

Regards,

Anirudh

Certified Master Anaplanner

Re: File imported in random order

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:

image.png

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

image.png

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

Let me know if this helps!

 

Regards,

Anirudh

Certified Master Anaplanner

Re: File imported in random order

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.