5 Replies Latest reply: Feb 19, 2013 10:56 AM by Zhenya Virina RSS

Linking fields

Zhenya Virina

Hi -


I have two tables that i need to link as part of my pie chart.


I was able to link these fields in a straight table using IF formula and now I am having hard time linking straight table values to pie chart for TAGS.




Table 1

Issue ID| Description| Tags|


Table 2

Issue ID| Description


Please help!

  • Re: Linking fields
    Gabriel Oluwaseye



    I would just JOIN the two table together.


    JOIN has variation with it, LEFT JOIN, RIGHT JOIN, INNER JOIN. Please note, using just JOIN with result in OUTER JOIN. So use approriate JOIN.




  • Re: Linking fields
    Nick Listerman

    Are you trying to get all records from Table 2 and only the tags from Table 1?  You will want to create the "link" or the join in your load script.


    Sample below will return all results for the Issue IDs


    'Table 1':
    Load * inline
              Issue ID, Description,   Tags
              1,   Desc1,  Tags1
              2,   Desc2,  Tags2
              3,   Desc3,  Tags3
    'Table 2':
    load * inline
              Issue ID, Description
              1,   Desc_Table2_1
              2,   Desc_Table2_2


    Issue ID Tags Description
    1 Tags1 Desc1
    2 Tags2 Desc2
    3 Tags3 Desc3