I have some problem, i want find your support please.
I have a source table "Medicament " and a target table "dim_medicament".
in Medicament i have two variables "PrixUnitaire" and "EtatMed"
PrixUnitaire is an float
and EtatMed is an integer (who take the 1 if medicament it's available and 0 if isn't)
In the target table , i want add a "Prix" variable who receive the "PrixUnitaire" if the medicament is available and 0 if isn't.
for dim_medicament.Prix i wrote this expression , and i found a some mistakes:
(Medicament.EtatMed = 1) ? (Prix = Medicament.PrixUnitaire) : (Prix = 0)
I ask your help above.
Solved! Go to Solution.
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.