Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 3 tables
Owner:
RecordOwner,
..
...;
Inv:
Id,
RecordOwner,
....
...;
NC:
Id,
RecordOwner,
....
...;
Below is my condition.
If(RecordOwner(in Owner Table) = RecordOwner ( in Inv Table) , Load "Id" data in Inv Table,
If(RecordOwner(in Owner Table) = RecordOwner ( in NC Table) , Load "Id" data in NC Table)
In my original script this condition is not included..
original script is as below.
NC:
Id,
RecordOwner,
....
...;
Left Keep(NC)
Inv:
Id,
RecordOwner,
....
...;
Left Keep(NC)
Owner:
RecordOwner,
..
...;
Please help.
Thanks,
Raghav
Hi ,
if you want to Keep Those Tables Separate without any Joins then you can use Where Exist function in the below two tables.
but before that i would like to see the all the fields from 3 tables because to check what are the comman fields between those tables.
attach the script or screen shot.
Thanks,
Mukram
Try like this
Owner:
LOAD
RecordOwner,
RecordOwner as KEY,
..
...;
Inv:
LOAD
Id,
RecordOwner,
....
...
where EXISTS(KEY,RecordOwner);
NC:
LOAD
Id,
RecordOwner,
....
where EXISTS(KEY,RecordOwner);
Hi Mohammed,
fileds which i mentioned are the only common fields. Rest all fields are used only for analysis.( they are no way related to each other)
can you please provide sample script as per your reply.
my requirement : base is RecordOwner from that
If(RecordOwner(in Owner Table) = RecordOwner ( in Inv Table) , Load "Id" data in Inv Table,
If(RecordOwner(in Owner Table) = RecordOwner ( in NC Table) , Load "Id" data in NC Table)
for below dont we need any Join condition>?
Inv:
LOAD
Id,
RecordOwner,
....
...
where EXISTS(KEY,RecordOwner);
NC:
LOAD
Id,
RecordOwner,
....
where EXISTS(KEY,RecordOwner);
Hi Raghav,
you can try using where exists function.
NC:
Id,
RecordOwner,
....
...;
Left Keep(NC)
Inv:
Id,
RecordOwner
Where exist (RecordOwner)
....
...;
Left Keep(NC)
Owner:
RecordOwner
Where exist (RecordOwner)
Many Thanks
Karthik
not required this is more efficient way to handle this scenario
This is exact requirement on which app needs to be built. Please help.
If the id # (from, Inv table ) is missing, then record owner name comes from the NC. Else, the record owner name comes from the inv.