Excel New column hour import

[Sally_Xu]

Hi,

As a beginner, I have a problem when I try to import a simple excel data in Harvest Timesheet. I want to insert new column “vacation hours left” in my Harvest timesheet table. And I go to she Harvest Time sheet, why the Vacation hours from Excel are blank? Did I assign the wrong Measure and Dimension?
Here I will attach the picture to show you

How can I assign them, I just want to show the vacation hours from Excel in my Harvest time table.
Thanks

[martins.vanags]

Hi @Sally_Xu

The default mapping in eazyBI would be “Key column” and in this case, the key of “Person” dimension members is ID, but your excel data don’t hold person keys.
Please use “name option” when you do the column mapping for your Excel data.
See the picture below.

Martins / eazyBI support