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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.