5 Replies Latest reply on Nov 8, 2018 3:59 AM by stian.vading

    Reverse splitting a datasource

    stian.vading

      Hi, I have a very large dataset (100 mb+) in this format:

      DESCRIPTION

      ID

      A\Node

      127\24

      B\Node

      140\24

      C\Node

      56\24

      x\A\Node

      1\127\24

      y\A\Node

      2\127\24

      x\B\Node

      2\140\24

      x\C\Node

      3\56\24

       

      In this simplified example the top Node is ID 24, the A is ID 127, B is ID 140 and so on.

       

      Splitting the nodes on the «\’s» gives me a separation like this

      Description Split 1Description Split 2Description Split 3ID Split 1ID Split 2ID Split 3

      A

      Node12724
      BNode14024
      CNode5624
      XANode112724
      YANode212724
      XBNode214024
      XCNode35624


      But now the top node 24. is now in both «ID split 2» and «ID split 3»...


      If I could reverse the order of the data splitting,  I would have solved this problem, but I cannot do it on the data source itself.

       

      This is how I want the split to look like:

      Description Split 1Description Split 2Description Split 3ID Split 1ID Split 2ID Split 3

      Node

      A24127
      NodeB24140
      NodeC2456
      NodeAX241271
      NodeAY241272
      NodeBX241402
      NodeCX24

      56

      3

       

       

      Do any of you Tableau gurus have a way for me to split this data so I can store the correct “mapping” of this data?

       

      As stated, the dataset I am working on is large and the speed of any calculation done on this data is paramount.