1 Reply Latest reply on Jul 15, 2016 11:39 AM by diego.medrano

    cross mapping, multi valued fields

    priti patil

      Hello Friends ! I need your help in following ;

       

      I have two columns in excel sheet, 1st column has names & other column has multiple alpha numeric codes separated by comma

       

      E.g

       

      ABC. E11A

      XYZ. A04F, E11A, G06A

      EFG. A04F, C09K

      XYZ. E11A, A04F

      ABC. G06A, E11A

      ......

       

      total 100 records with cross references

       

       

      I need to create cross reference matrix names vs codes & create a 3D graph in tableau &/ Excel

       

      pic of the graph is as attached.

       

      Any pointers please ?