3 Replies Latest reply on Sep 18, 2017 10:17 AM by Cecilia Saldaña

    tabcmd export csv automatically convert metrics from column to row

    sia zhang

      I have built a tableau report and tried to use tabcmd for exportation.

       

       

      The table looks like this:

      Dimension1,Dimension2,Dimension3,metric1,metric2,metric3,metric4,metric5,metric6,metric7,metric8,metric9,metric10,metric11,metric12,metric13,metric14.

       

       

      I use tabcmd command:tabcmd export "url" —-csv -f "report.csv"

       

       

      It generate a csv but metrics got converted to rows. Now the report looks like this:

       

       

      Dimension1,Dimension2,Dimension3,Measure Name, Value

                                                                        Metric1

                                                                        Metric2

                                                                        Metric3

                                                                        Metric4

                                                                        Metric5

                                                                        Metric6

                                                                        Metric7

                                                                        Metric8

                                                                        etc,.

       

       

      Tableau, is there a way to export the csv as it is? Why it automatically converted to this format? No one can read it easily this way.

      Is there a way to fix this?

       

       

      Thanks so much!