Left join 2 table + 2 fields

[PaoloGuerra]

I all.

i have two table with different fields and I join\combine information.

Table1
UserAccount	Name

Table2

DB_User_Name_Comb_Machine_Learning

If DB_User_Name_Comb_Machine_Learning is = UserAccount

then  I add a new field to table 2 like this:

Table 2
DB_User_Name_Comb_Machine_Learning	Name

My code work fine:

Left Join (Comb_Machine_Learning)
LOAD
	*
;
LOAD
    UserAccount as DB_User_Name_Comb_Machine_Learning,
    UserAccount as tmpDB_User_Name_Comb_Machine_Learning,
    Name
FROM [lib://SOURCE.xlsx]
(ooxml, embedded labels, table is Foglio1);

LOAD
	DB_User_Name_Comb_Machine_Learning,                                      
	IF(DB_User_Name_Comb_Machine_Learning = tmpDB_User_Name_Comb_Machine_Learning,Name,null()) as Name
Resident Comb_Machine_Learning;

But now, I need to use not one but two conditions with others tables like this

Table1
ApplicationName	ServerIP

Table2
DbNameServer	DbServerIP

My goal:

IF DbNameServer = ApplicationName and If DbServerIP = Server IP

add ApplicationName into Table2

Can you help me please?

Thanks

[Channa · Accepted solution]

this is no issue u almost there

IF( DbNameServer = ApplicationName and DbServerIP = Server IP)

just remove if