Hi All,
I need some design suggestions on my requirement below .
I have a excel which has around 1000 rows and has 5 columns . All four columns are some labels and the last column has VALUE(Sample below)
My requirement is to upload this excel file and save into Appian DB but before i save this data i want to perform some validations on VALUE column let say :
1. first 5 rows should fall into tolerance band of 100-200
2. Next five rows should fall into tolerance band of 10-35
3. first 5 rows should sum upto 100
If values doesn't pass above validations then i need to tell user to re upload the excel with correct values .
Thanks in advance
Discussion posts and replies are publicly visible
This you can achieve by providing the upload file interface component.
Reading the file in the process
Create an expression to select the number of rows
Keep the timer for delay if you want to delay the row writing.
Let me know the definition of tolerance band with respect to your explanation. Because its more relevant to resistors in electronics.