5 Replies Latest reply on Jul 30, 2015 2:58 AM by Mark Fraser

    How do I import data with missing rows

    Dale Carnell

      Hi, I am new to Tableau and evaluating whether I could use this tool in our business.

      I primarily use Adobe Data Workbench (formally Insight) and the data is exported to excel in the format below.

      I am struggling with the data import stage as rows which have blank Country and Month dimension cells are not added. I need to know if there is a way to repeat above rows. Whilst it is easy enough to do this in excel for small datasets, it would be problematic for larger ones where I need the visualisation abilities of Tableau.

       

      Tableau excel.jpg