Relationships between data objects

[#1]

Hi there,

I have a data set like the below.

I'd like to figure out how I make a link between TABLE1.TASK DEPENDENCY and the TABLE2.TASKID

I would like to be able to click on 'Task 1' in this table and for it to filter the TASKS table to show only that task. The problem is, they're stored in different tables, with different field name.

Additionally, if the RAG status for TABLE2.TASKID is RED, I'd like to show the cell in the dependencies table as having a red background,

Can anyone help?

[settu_periasamy]

It would be easy if you post some script? Looks like your table is Qualified.

If you want to link between TABLE1.TASK DEPENDENCY and the TABLE2.TASKID,

you need to change one your field name. Then, it will automatically link..

Like

Qualify *;

Unqualify TASKID;

TABLE1:

Load [TASK DEPENDENCY] as TASKID

From Source;

TABLE2:

Load TASKID from Source;

[avinashelite]

could you please share the sample data of those two tables ?? so that we can suggest a better solution

[deepakqlikview_123]

You can simply rename the field

[Anonymous]

lookup function is used

[#6]

Hi there

Here is table one. You can see REF is linked to REF in the table 2 (below).

Essentially, IF RAG in table 2 = RED and Status in table 2 = OPEN

THEN the row in table 1 should be highlighted in red

Here is table 2:

[#7]

Aha, I have solved this.

The problem was that I was using a table box, not a straight table. Once I had done this, I can add background colour:

=IF([Issue RAG]='RED', lightred(), IF([Issue RAG] = 'AMBER',  yellow(), IF([Issue RAG]='GREEN',LightGreen(),

IF([Risk RAG]='RED', lightred(), IF([Risk RAG] = 'AMBER',  yellow(), IF([Risk RAG]='GREEN',LightGreen(),

IF([Action RAG]='GREEN',LightGreen(), IF([Action RAG]='RED', lightred(), IF([Action RAG] = 'AMBER',  yellow(),white()

)))))))))