Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
Once again Sunny you the man. Want to help me with SSO ticketing in .net?
I have no knowledge on this topic. I wish I could have helped you with it.
Best,
Sunny