Concatenate with Join and with Resident Load

[billuran]

Hello I Have 3 tables i am concatenating then doing a left Join to attach a key. I am then doing a resident load of this new table with a where clause to exclude a certain key. However its not working. Here is the example

Payroll:

Load

     field-a,

     field-b

from;

Concatenate

Load

     field-a,

     field-b

from;

left join

Load

     field-b,

     keyid

from;

NewPayroll:

Load

     field-a,

     field-b,

     keyid

Resident Payroll

where keyid<>'Provider';

Drop Table Payroll;

The table comes out blank. Help please.

[sunny_talwar · Accepted solution]

Try this

Payroll:

Load

    field-a,

    field-b

from;

Concatenate

Load

    field-a,

    field-b

from;

left join

Load

    field-b,

    keyid

from;

NewPayroll:

NoConcatenate

Load

    field-a,

    field-b,

    keyid

Resident Payroll

where keyid<>'Provider';

Drop Table Payroll;

[billuran]

Once again Sunny you the man. Want to help me with SSO ticketing in .net?

bill.uran@hcopt.com

[sunny_talwar]

I have no knowledge on this topic. I wish I could have helped you with it.

Best,

Sunny