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.
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