Script help

[Anonymous]

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

[mdmukramali]

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

[avinashelite]

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);

[Anonymous]

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)

[Anonymous]

for below dont we need any Join condition>?

Inv:

LOAD

Id,

RecordOwner,

....

...

where EXISTS(KEY,RecordOwner);

NC:

LOAD

Id,

RecordOwner,

....

where EXISTS(KEY,RecordOwner);

[karthikoffi27se]

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

[avinashelite]

not required this is more efficient way to handle this scenario

[Anonymous]

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.