CSV Handling - Blank first row

When a CSV is imported if the file does not have headers and the data in last column (or multiple last columns) of the first row is blank the last column is ignored and not available as part of the import.

How often is this impacting your users?

This impacts multiple clients, when it is an issue then it impacts frequently.

Who is this impacting?

Customer users of all types

What would your ideal solution be? How would it add value to your current experience?

In the import screen we currently choose Header Row and First Data row. Could an additional selection be made for "Column Format". This would work as follows:

  1. If a Column Format is selected Anaplan uses this row to identify how many columns are in the file. If there are more columns than Headers the missing headers should be filled in as Column 1, Column 2 etc
  2. If there is no column format selected and there is a header row, ANaplan uses the header row to define the columns
  3. If there is neither a column format or a header defined then Anaplan uses the first row of data to define the columns

Please include any images to help illustrate your experience.

3
3 votes

New ยท Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In