Importing Excel Data into Dataiku

Options
davidhernandez
davidhernandez Registered Posts: 19 ✭✭✭✭
in General Discussion

I am importing my Excel Worksheet into Dataiku, but for some reason my headers are not matching with my data. When uploading a data table into DataIKU, I normally keep the column as it is in the source file, and use a recipe to rename the column later. We can probably manually fix the data, but Dataiku should automatically arrange the data to the correct column. It looks like some of the column data has shifted. What can I do to fix this?

· Share on FacebookShare on Twitter

Answers

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 365 Dataiker
    Options

    Hi @davidhernandez

    Can you please post a screenshot of this behaviour (from Excel and from DSS) as this is something that is uncommon to get?

    · Share on FacebookShare on Twitter
  • Mark_Treveil
    Mark_Treveil Dataiker Alumni Posts: 30 ✭✭✭✭✭
    Options

    Hi David,

    I suggest that you have a very close look at the data around where the problem starts, and the delimiters being used to identify a new column.

    The chances are it is an unwanted delimiter in the data - or a missing one.

    good luck

    Mark

    · Share on FacebookShare on Twitter
  • davidhernandez
    davidhernandez Registered Posts: 19 ✭✭✭✭
    Options

    As an update to my question, I was able to click into the icon in the flow, select Settings, and then select the blue TEST button. After that, I selected PREVIEW, and selected at the very top a button to fix the columns. It now says: "Schema and data are consistent"

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…