Data import from excel to List

HI all,

I am loading data from excel to List and i have blank entries in the excel sheet which has business meaning, hence i am bit struggling to maintain blank entries in the list or how Anaplan recognizes the blank entries from excel records and loads automatically to the list.

-Santosh

Accepted answers

All comments

naushad786

Hi @CommunityMember128217 ,

can you please share the screenshot or mock-up?

Regards,

Naushad

CommunityMember128217

HI naushad786 ,

I just want to maintain blank entries into list as this has business meaning behind.

And I have in my excel such entries(Blanks) when i load to list i do not see those blank entries as Anaplan does not recognize it.

Anyway I have Added the excel example in the attachment to get some idea. PFA.

Thanks,
Santosh

Anaplan_issue_72539.PNG

prabhu

Hi @CommunityMember128217 -

Blank Entries meaning - you want to create a action.

The purpose may be, the business don't want to share some data as a file with you.

What you can do is :

1. Ask for column header(Fixed) - So that you can map accordingly while creating an action.

2. Create a CSV file and add only Column headers and run the action.

Now run the action - you won't get any record in list.

I am not getting what you mean "i am bit struggling to maintain blank entries in the list"

Can you provide some screen shot for better understanding.

Thanks,

Sorna Raja Prabhu

CommunityMember128217

Hi Sorna Raju,

Not everything in excel file is coming blank. one or two records and it has business meaning.

See below.

I am Loading data to List and i need to see in the list 5 records(O1,O2,O3,O4 and blank)

Organisations

+Santosh

naushad786

Hi @CommunityMember128217 ,

As you attached the screenshot, you can maintain blank entries using Unique ID. for that you need to create a number list display property as "Display Name".

Thanks,

Naushad

Kanishq17

Hi @CommunityMember128217 ,

in case you keep organisation as a general list as blank, anaplan will fail blank entries when you import into the list

this is because anaplan identifies each unique list member by its name in a general list

so you get only the non-blank entries

if this is feasible or not, bit what you can do is create the organisation list as a numbered list , and add a display name property and map the column org name to the display name property and import using org code,

so it wil create 5 entries with 1 as the anaplan generated id i.e without a display name

here as you can see 5 entries are created but if display name is blank, it will show id name

amitchavan

You can use 'Combinations of properties' option to upload data and make sure your list is numbered list.

Screen_shot_72626.PNG

Quick Links

Can you help?

Unanswered questions

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…
Predefaulting A Feild in ANAPLAN
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…
Looking for Anaplan End-Users to take a short survey!
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.…