Hello I load the information from a QV mitmas (Articles) I have to go retrieve information on the QV MITAUN (Units), with the key item code / Buying Unit The condition is the following: If the key does not exist I want to have 1 If the key exists and the area MUDMCF QV MITAUN is 2, I want to have the value of the area MUCOFA QV MITAUN If I want to have 1 / MUCOFA as value Thank you Here's the current request does not work:
LOAD text (MMITNO) as CodeArticle, text (MMITDS) as LibArticle, text (MMITNO) & '& text (MMITDS) as CleArticle, text (MMHIE1) as Hie1, text (MMHIE2) as Hie2, text (MMHIE3) as Hie3, MMGRWE, MMNEWE, MMSTAT have StatutArticle, text (MMSPUN) as UniteAchat FROM $ (VDirExtract) MITMAS.QVD (Qvd);
LEFT JOIN (DMP_ARTICLES)
LOAD text (MUITNO) as CodeArticle, text (MUALUN) as UniteAchat, If (isnull (MUDMCF), then 1 // , If (// otherwise MUDMCF = 2 , // Then MUDMCF 1 / MUCOFA // otherwise ) ) as COEFF FROM $ (VDirExtract) MITAUN.QVD (Qvd) WHERE MUAUTP = 2;
