i have Entities Product and DMF field, In Product entity Product name, Route Code, NC-1 status, Mfg site, Storage . In DMF field entity Product ID and CountryID, IS DMF fields are there.
How to import the given below excel file format
Hi SreenivasuluReddy,
I will try to help you, simply you have to right click on Database<<Entity
you can click the option "Import new entities from excel". for example I select employee file then you proceed to importyou can see the sheet1 has imported with sub header in you system after that just update entity name i.e sheet<<Employee
hope this has been made clear!
Thanks
Hi @Ankur Manekar
It's not Working
Hi SreenivasuluReddy Lingala ,
It is not possible to have Sub Headers to create the entity records.
https://success.outsystems.com/documentation/11/reference/outsystems_language/logic/implementing_logic/logic_tools/excel_to_record_list/
Two work arrounds I would suggests you.
1. As you know ,In OS best practices we have referential integrity for entities.
You can create another entity(Table) for DMF].
2. You can create number of attributes to store in exsisting table.
Hope this will help you.
Reagrds,
Amreen