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.

       

      =if(left([issueID],3)='ABC',('Testing'),[tags])

       

      Table 1

      Issue ID| Description| Tags|

       

      Table 2

      Issue ID| Description

       

      Please help!

        • Re: Linking fields
          Gabriel Oluwaseye

          Hi,

           

          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.

           

          Regards,

          Gabriel

          • 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':
            
            OUTER JOIN
            
            load * inline
            [
                      Issue ID, Description
                      1,   Desc_Table2_1
                      2,   Desc_Table2_2
            ];
            

             

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