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