3 Replies Latest reply on Jul 12, 2013 6:53 AM by russell.spangler

    I'd like to link 2 tables that shared a common field (Excel).

    ZhaoYong Phua

      I'm new to Tableau 8.0.

       

      I wish to link 2 tables that shared a common field. The only problem is, 1 of the table contained string text with comma separating the text.

       

      I've provided some example below

       

      Table 1
      314 158, 314 213
      314 158, 314 213
      314 455, 314 456, 314 457
      314 455, 314 456, 314 457
      313 931, 313 932, 313 933
      313 929, 313 930, 313 933
      0
      133 043, 133 044, 133 045, 310 718, 310 719, 310 720, 400 039, 400 040, 400 041
      310 718, 310 719, 310 720, 400 039, 400 040, 400 041
      310 718, 310 719, 310 720, 400 039, 400 040, 400 041
      310 718, 310 719, 310 720, 400 039, 400 040, 400 041
      310 718, 310 719, 310 720, 400 039, 400 040, 400 041

       

      Table 2
      3000 082 003
      3000 951 210
      3000 332 001
      3000 990 232
      115 476
      170 141
      200 954
      105 748
      170 814
      556 293
      115 475
      105 740
      115 158
      170 811