4 Replies Latest reply on Jul 18, 2018 9:55 AM by Paco Matt

    Source Data Changes

    Paco Matt

      Hi all,

      I need to create a script or process to change my source data to an specific format. Please look to the example below:

      Initial raw data format

          

      Code1Type5UserNameDepartment
      2154464685678567JohnParts1
      5454464675678567JamesParts2
      5454464686678567TimParts3
      6578864626678567JK23Warehouse
      5454464675678567TommyDesktop
      8954464675678567JORGEDWarehouse
      5454464675678567JohnDesktop
      5454464675678567JamesWarehouse
      5354464675678567JohnDesktop
      2554464675678567JamesWarehouse
      5454464696678567JohnDesktop
      5454464675678567JamesParts1
      9654464642678567TimParts2
      5454464675678567JK23Parts3
      4254464675678567JK23Warehouse
      5454464675678567TommyDesktop
      5354464655678567JK23Warehouse
      5454464652678567TommyDesktop
      7354464686678567GEANMWarehouse

       

      Now the desired data format for Tableau (I prefer to create this change in Tableau after downloading the initial raw data)

         

      LinkStep 1Step 2SizeUserNameDepartment
      link21544646856785671JohnParts1
      link54544646756785671JamesParts2
      link54544646866785671TimParts3
      link65788646266785671JK23Warehouse
      link54544646756785671TommyDesktop
      link89544646756785671JORGEDWarehouse
      link54544646756785671JohnDesktop
      link54544646756785671JamesWarehouse
      link53544646756785671JohnDesktop
      link25544646756785671JamesWarehouse
      link54544646966785671JohnDesktop
      link54544646756785671JamesParts1
      link96544646426785671TimParts2
      link54544646756785671JK23Parts3
      link42544646756785671JK23Warehouse
      link54544646756785671TommyDesktop
      link53544646556785671JK23Warehouse
      link54544646526785671TommyDesktop
      link73544646866785671GEANMWarehouse

       

      As you can see, it add two columns (Link and Size with fixed values before and after Step 1 and Step 2) and renamed Type5 with Step 1 and UserName with Step 2 I'll appreciate your help if this can be possible in Tableau.

       

      Thanks for your time!