Creating a new field from multiple tables

[momofiore]

Hey guys

is there any problem with this script? im trying to create a new field cold Is_AutoCap_NewIt2_3  with the help of 3 field from 3 tables:

-IsAutoCap from FactTicket

-ActivitySDTier from FactTicketActivity

-[Catégorie H2] from Applications

after the script done i just get 'NO'  for Is_AutoCap_NewIt2_3 

this script works perfectly when i try it with with 3 field from the same tables. but not defferent tables

Temporaire:

LOAD %TicketKey,%CIApplicationName,Ticket,IsAutoCap

Resident FactTicket;

Left Join(Temporaire)

LOAD %TicketKey,ActivitySDTier

Resident FactTicketActivity;

Left Join(Temporaire)

LOAD %CIApplicationName,[Catégorie H2]

Resident Applications;

Left Join(Temporaire)

LOAD %TicketKey,%CIApplicationName,

if(IsAutoCap =1 AND ActivitySDTier =3 AND [Catégorie H2] ='NEW IT T2','YES','NO') as Is_AutoCap_NewIt2_3

Resident Temporaire;

Left Join (FactTicket)

LOAD %TicketKey,%CIApplicationName,Is_AutoCap_NewIt2_3

Resident Temporaire;

Drop table Temporaire;

here you can see the result

stevedark‌

[momofiore]

thanks youssefbelloum‌ . but you can see in the rows 8,9,10 ActivitySDTier  is null but even it shows YES .

here is a picture for a list box and combinations

when i filter with 'YES' --> mistakes in row 1,2 and 4

and here is when i filter with 'NO' --> mistake in rows 3

thanks again

[momofiore]

if you think my script to make  temporaire table with left join is not correct you can suggest an other way to create Is_AutoCap_NewIt2_3 from the 3 tables. thanks

[momofiore]

heeey youssefbelloum‌ i add some samples.

you can take what you want from this table it contain all column from the 3 tables

thanks again for your time

[momofiore]

youssefbelloum‌ have you recieved the data?

[YoussefBelloum]

take a look, it seems that is working fine also here