Thank you for reading this post. The logic I have created for "Importing Data from Excel" seem to be incorrect. May I ask for assistance on this little project I'm doing?
1. I have an excel file that I want to import. Here is the structure below.
2. The Data model is this. The [Name] column is to be stored into an entity called Students while the [Subjects] column is to be stored into another entity called StudentSubjects.
3. THE PROBLEM; my logic doesn't seem to store/import all the subjects (Science, History, Math, Health) into the StudentSubject entity. I used String_Split action to split (",") the [Subject] column from the excel file.
When I import the excel, THE OUTCOME is that only one subject is created on the StudentSubject entity.
I have attached the .oml file and the excel file I used as a test for importing for your review.
Thank you and best regards,
Hey Jane, Happy to help you here...
What you need to do is, just after the String_Split, loop its result, and than do the Get/Assign/Create StudentSubjects objects.
Hope it's clear now.. ;)
João Melo wrote:
Hi Mr. João,
Thank you for taking the time to answer my question but I'm afraid I don't follow. I'm new to Outsystems and can't seem to understand the logic you want me to do. Can you please explain more clearly?
Sure... See oml attached and image bellow...