Hi I need to validate if the correct excel is uploaded by validating its content . I have different excel upload for different activity. If the user uploaded wrong Excel and do the submit it should display that excel is not for this activity .
Is there any way to do that.
Can anyone suggest a way and how to implement it.
Discussion posts and replies are publicly visible
It depends on what the Excel files look like but you should be able to accomplish this by using the
From the Excel Tools plugin: community.appian.com/.../excel-tools
This depends a lot on how you want to implement this validation. A real validation would always mean to first read all data, and then run a validation rule. Out of scalability considerations, I typically import all data into a staging table first. The next step would be your validation, followed by a transformation step using a stored procedure.
Could please provide the implementation code of the post staging table insertion validation I can use or adapt for me. That would be helpful.
There is nothing I could share, and the implementation is very specific to your use case.
What I was asking is how to do the validation like if there is any function i can use , how can i implement the validation.
No, there is no specific function you could use. This means to implement a stored procedure in the Maria DB.
Data type or length validation can be done via Stored proc and if you want to do some referential value validation then those can be done via appian expression as well.
Pull referential value and compare particular column data by doing read excel
You can create Excel upload framework as well if dealing with various time of excel upload templates