Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
this is no issue u almost there
IF( DbNameServer = ApplicationName and DbServerIP = Server IP)
just remove if
this is no issue u almost there
IF( DbNameServer = ApplicationName and DbServerIP = Server IP)
just remove if