how to write expression based on status in two tables

[Sra1bandi]

Hi Team,

I have two tables with different data with one primary key 

TABLE1:-

load* ,inline[

Id ,  Wf_Status

1,     Closed

1,    open]

Table2:-

load* ,inline[

Id ,  TK_Status

1,     Completed

1,     Completed

1,    Started

1,    ready

1,    Committed]

My required table is 

in 1st table when i filter with Wf_status='Open'

in 2nd table i need to exclude TK_Status='Completed' need to show other three values.

Output  data====>

Table1:

Id      Wf_Status 

1        open

TBLE2:

id     TK_Status

1         Started

1        ready

1        Committed

Regards,

Sravan.

[BrunPierre]

@Sra1bandi As below.

Table2:
load * inline[
Id , Wf_Status
1, Closed
1, Open ]
Where Match(Wf_Status,'Open');

Table2:
load * inline[
Id , TK_Status
1, Completed
1, Completed
1, Started
1, ready
1, Committed ]
Where Match(TK_Status,'Completed') = 0;

[sidhiq91]

@Sra1bandi  You can try something like below too:

NoConcatenate
Table2:
load * inline [
Id , Wf_Status
1, Closed
1, Open ]
Where Match(Wf_Status,'Open');

NoConcatenate
Table2:
load * inline [
Id , TK_Status
1, Completed
1, Completed
1, Started
1, ready
1, Committed ]
Where not Match(TK_Status,'Completed');

Exit Script;

[Sra1bandi]

Hi Both

Thanks for reply but i need in front end not in back end 

i have two tables 

i need to show all data 

when i select open cases in table then only i need to apply above mentioned conditions 

Reagrds,

Sravan.

[BrunPierre]

In that case, use Wf_Status and TK_Status fields as filter panes/list boxes?