5 Replies Latest reply on Dec 6, 2018 3:56 PM by Elizabeth Ancin

    Splitting rows with the same name

    Elizabeth Ancin

      My Excel Doc that I input into Tableau is in a format that looks like:

      SystemSub-System 1Sub-System 2
      Value
      SystemAntennaCable1
      SystemAntennaConnector1
      SystemAntennaSwitch1
      SystemAntennaSwitch3
      SystemAntennaSwitch5
      SystemDown linkCable1
      SystemDown linkConnector1

      And when it's input into tableau the table appears:

      SystemSub-System 1Sub-System 2
      Value
      SystemAntennaCable1
      SystemAntennaConnector1
      SystemAntennaSwitch9
      SystemDown linkCable1
      SystemDown linkConnector1

      The switches are all being combined and their value summed together, however I need to split these back into three separate rows with their 3 separate values outputted.  I tried to make another column and calculate using index() but it is just counting my rows, I'm not sure what I'm missing.  Any help is much appreciated!