1

To learn Datazen i begin with excel tables but I've some problems.

I have a name column and a value column like this:

tableData

But when i import it into datazen the data become:

datazentable

And Datazen doesn't recognized data as string and it's not possible to create a chart with names column. I've tried to change the format cell into text but there's no effects, someone can help me? thanks

Huojian
  • 198
  • 2
  • 14
  • Try to change cell type for first column as `Date` and the second column as `Number`. – gofr1 Mar 29 '16 at 09:14
  • Not work, note that it works if I add a row with a column ('AAA', '0') but it changes the name into '201' instead of '02.01' – Huojian Mar 29 '16 at 09:33
  • Try putting a column name into the first row (above NOMS / ID) – Daryl Wenman-Bateson Apr 04 '16 at 09:37
  • Same problem, i have changed the '.' into '_' and it works, i think there is no solution to use this format into string with Excel files( with a SSAS connection, I can change the format for each column ). – Huojian Apr 04 '16 at 11:00

0 Answers0