Forum Discussion

phantomias33's avatar
phantomias33
Regular Visitor
2 years ago
Solved

Trying to import a seemingly simple excel sheet.

While this seems straight-forward, I'm getting tripped up.  Below is data from Excel that shows a management team and their projected Headcount needs for the rest of the year.  (Between the Youtube v...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    You have to select all columns other than the Month column and then use "Unpivot Other Columns".  Before that ensure that there are no total/subtotal rows.  Also, in the Source step itself, the headers of the table should be the ones that you posted in the first message.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

In the Query Editor, select the first 2 columns, right click and select "Unpivot Other Columns".  Rename the attribute column as Date.  Ensure that the data types are proper.  Click on Close and Apply.  Now build your visuals/write your measures.

  • phantomias33's avatar
    phantomias33
    Regular Visitor
    2 years ago

    Thank you!  I think you've got me just about there.   I can rename the 'Attribute' column to 'Date' but the values in there are just text (see below) and not actually the dates.  I should mention, the below is if I delete the top row from my original post.

     

     

    If I don't delete the top row from the original post, I end up with the below.

     

     

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      2 years ago

      You have to select all columns other than the Month column and then use "Unpivot Other Columns".  Before that ensure that there are no total/subtotal rows.  Also, in the Source step itself, the headers of the table should be the ones that you posted in the first message.