Level 2 1.5.2 Activity: Import data into Beginning Inventory

Rudus · 2025-05-14T07:51:00+00:00

There was an error rendering this rich post.

Hi, I have problems importing the beginning inventory into DAT 01 module. Mapping looks like this. There is an extra column with numbers. What should I do with this column and how should it be mapped? I assume the beginning inventory and this extra column should be together, so that the first line should have a beginning inventory of 13000?

How can a map the SKU? I suppose these are not meant to map manually?

Could anyone help me? Thanks.

Accepted answers

All comments

devrathahuja

Hi @Rudus ,
Check the separator you're using in the file & in the import action.

It could be due to a mismatch between the ; & , used to separate columns.

Rudus

Hi, It looks like this. What should I do differently? I have tried different options but nothing helps.

devrathahuja

Hi @Rudus ,
Can you try changing the separator from comma to semicolon in the column separator here & see if that works?

Rudus

Hi, it does not work.

devrathahuja

Hi @Rudus ,
Can you attach the source file as is downloaded without opening/resaving it?

It looks like you have additional "" in the data. The data in the file should look something like-
P001EN,G001,13000

Rudus

Hi,

Now it works, thanks. It seems that the problem was that I had open the file before importing it.

devrathahuja

@Rudus - Yes the excel then applies your local settings which sometimes ends up messing the data. Glad it works now :)

Happy learning!

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…