Linking fields

[#1]

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!

[Gabriel]

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

[Anonymous]

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

[#4]

Hi Nick,

I am trying to create a link between 2 tables and combine all of the records, not only tags. What would be the best way to do this in a formula?

Thank you!

[Anonymous]

do you have sample data or able to provide your table designs?

If both tables share the same unique ID column name, the join method will automatically link the fields and the fields in both tables will be available.

[#6]

Both tables do not share the same unique ids'. The only thing that is shared is the table name. Does that help?