table join with different column names

Thu, 05 Feb 2015 12:53:51 GMT

i have two tables like this.

Margin:
LOAD [SC-IM],
     GROUP, 
     [Job Name], 
     DESCRIPTION, 
     [Critical ?], 
     SLA,   
     [Last Run date],
     [Last Run time],
     trim([Last Run Timestamp]) as [Last End Timestamp],
     trim(PREDECESSOR) as Predecessors, 
     trim(SUCCESSOR) as Successors
Resident Temp order by [Last Run Timestamp] asc,[Job Name] asc;
      
SUCCESSOR:
LOAD [Job Name]  as "Parent Job",
trim(mid(trim(subfield(Successors,',')),2)) as "Child Job"
Resident Margin order by [Job Name] asc;

Now i have to create two table objects like. If a "Job Name" is selected from List

1. object-Table1 should list all the columns of "Margin" table -- done

2. object-Table2 should look up "Margin".[Job Name] for each value of "SUCCESSOR".[Child Job] and list all detail for that Child job from "Margin"-- Is it possible ?

Any help is highly appreciated. Thanks in advance

MidhunGT

Re: table join with different column names

avinashelite — Thu, 05 Feb 2015 13:00:33 GMT

try like this:

add a column like this

Margin:
LOAD [SC-IM],
GROUP,
[Job Name],
[Job Name] as "Parent Job",
DESCRIPTION,
[Critical ?],
SLA,
[Last Run date],
[Last Run time],
trim([Last Run Timestamp]) as [Last End Timestamp],
trim(PREDECESSOR) as Predecessors,
trim(SUCCESSOR) as Successors
Resident Temp order by [Last Run Timestamp] asc,[Job Name] asc;
SUCCESSOR:
LOAD [Job Name] as "Parent Job",
trim(mid(trim(subfield(Successors,',')),2)) as "Child Job"
Resident Margin order by [Job Name] asc;

This should work.

topic table join with different column names in QlikView

table join with different column names

Re: table join with different column names