Log in to AnswerLog in to Follow
UserImage.jpg
gade ganesh kumar
14Views
2Comments
Compare excel column with my entity
Question
Reactive
Application Type
Reactive

Hi Everyone 

I would like to know How to compare my excel columns with entity columns, suppose If column mismatch happen I should be able to raise the exception manually using out systems.

Thanks & Regards 

Ganesh kumar

0
0
08 Feb

Hello Gade Ganesh Kumar,

You can  use the Excel to Record action to turn your columns in to a Outsystems structure and compare the values that way. 

If you are using a reactive App you first have to create a Upload action and then call a server actions to be able to process the Excel.

Il leave an attached .oml with an example. 

This component can also help. 

Hope it helps ! 

Paulo Rosário

CompareExcellWithEntity.oml

0
0
08 Feb

I am unable to understand the OML you provided

This is my screen  for  selecting files, so if i select a particular file, and the values is not matching the datatype( for example Register numbers column only Integer should be accepted and not any text values), it should throw an error message saying that in this particular row the data is not matching.

0
0
08 Feb
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.