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;
