Bonjour à tous,
j’ai un fichier excel qui contient des données obligatoires et facultatives pour chaque ligne de transactions,
comment puis je vérifier pour chaque transaction que les données obligatoires sont bien remplies?
je vous remercie en avance pour votre aide
if you want to check it ony by one you can simply use a read cell activity and check if its not empty
if you want to check row by row you can simply use a read range range activity and start checking if its null or empty
then get and a condition: if one of those parameters does not cumply with your bussines rule then your transaction cannot be complete
best regards!
1 Like
Thanks a lot, i’ll try this
1 Like
Assumption:
- Definition of an array of ColumnNames which are mandatory
- Check will be done on: not null or Empty
- result: true / false based on check the entire datatable
Find starter help:
Check_isMissingMandatory_ColSet.xaml (8.3 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.