Log in to AnswerLog in to Follow
UserImage.jpg
Chennamsetty Anil
11Views
1Comments
Before insert the values check the datatype of the values in excel
Question
Reactive
Application Type
Reactive

Hi Everyone

I want insert the values in entity through the excel but before insert the values  I want check the datatype of the values with the row number and if datatype is different I want insert that row number in another entity


0
0
08 Feb

Hi Chennamsetty Anil,

By default, OutSystems provide some prefined functions that you can use to validate the data type you need to validate. Some of them are mentioned below. See if this can help. This will return True for success and false if they are not of the mentioned type.

You need to loop through the list that is fetch from Excel and use this function on the columns you want to validate.

LongIntegerToIntegerValidate()""
TextToDateTimeValidate()
TextToDateValidate()
TextToDecimalValidate()
TextToIntegerValidate()
TextToLongIntegerValidate()
TextToTimeValidate()


Thanks

Pranav

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