4 Replies Latest reply on Dec 7, 2018 11:40 AM by joshua.medernach

    Creating duplicate Rows?

    joshua.medernach

      Is it possible to duplicate a row in Tableau?

       

      Right now, I have a dataset from a production tableau server, whose workflow I cannot modify - so I am stuck with a tableau server connection as my data source.

       

      I've tried methods like duplicating the data source connection (by right clicking on the data source and clicking Duplicate,) but I couldn't figure out how to Union these two duplicate data sources together.

       

      An example:

       

      Given 1,000 rows, I am trying to create a single duplicate for each row containing original row data. This would mean I would have 2,000 rows as of result.

      In a new column, I am also trying to mark the original row as "A" and the duplicate row as "B" to distinguish between the two duplicate rows.

       

      So given a row, that looks like this:

       

      AppleFruitSeeds

       

      I am trying to produce the following result (note the new column to distinguish between the two rows.

       

      AppleFruitSeedsA
      AppleFruitSeedsB

       

      I've tried googling this, but all results were about removing duplicate rows - not creating duplicate rows!

       

      Help is appreciated, thanks!