How to validate that the order of attributes in the structure matches the column order in the uploaded Excel file?
I’ve already reviewed the Advanced Excel Forge component, but I need guidance on how to use it effectively to validate the column order of an uploaded Excel file against a predefined structure.
Hi @SreenivasuluReddy Lingala,
Please avoid posting the same question multiple times. You’ve already asked this question here. https://www.outsystems.com/forums/discussion/102711/how-to-validate-the-order-of-attributes-in-the-structure-matches-the-column-order/
Thank you.
In OutSystems, structures are statically typed, which restricts direct iteration over their attributes at runtime. Instead, it is necessary to manually append the attribute names initially, followed by opening the Excel file and saving the header names in a separate text list. I added comments for better understanding.
Hi @Sakthivel P Thanks for responding,
i am trying based on your sent logic but i am stuck in ListAppendAll Properties,
Please send me the Properties of that action and also ListAppend properties also
Thanks & Regards
SreenivasuluReddy Lingala.
Append all structure attributes name in EmployeeStructure variable.
Hi @Sakthivel P
Same logic tried it should not worked, any other solution is there for validation of headers order
Could you please share the implemented OML with me? It would be very helpful for my further understanding.