Hi, I want to import csv file.
But the data was enclosed by double quotation in text file.
Are there any problems when I import this type of csv file?
Not as long as you set the right data types all these should be in text formatted line items then you can covert them to numbers on Anaplan. CSV is nothing but comma-separated values you can import anything as long you are using the right formats.If you still face any issues feel free to do so here.
You can configure the structure of the import file in the first step of the import process. See here for more information: https://help.anaplan.com/8d55fc47-e743-4630-b619-2481fa8645ae-Import-data-into-modules-from-a-file
Note the option for Text Delimiter can be double quotes.
By the way, in your screenshot, it looks like the date is missing a starting quotation mark, so you'd probably get an error when trying to import the data.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…
