Question

Import data to two or more tables in Mendix

1

Hello, I need to import data from an excel spreadsheet into two or more different tables and link them as in the spreadsheet. for eg if there are entities like Employee, department and area, and the spreadsheet has columns like department,employee,area eg: HR | John, Robin | London Admin | Bill, Tony | London Please help me with this. Thank you. Regards

asked 2014-08-20

Prathibha Pandurangi

2 answers

Rom van Arendonk · Answer 1 · 2014-08-20

Create a separate module where you have an entity to store the raw data from your excel sheet. Then, when you have imported the data, run another microflow on these newly created objects to import them into your usual entities.

Chris de Gelder · Answer 2 · 2014-08-20

If fact you can import them in one run with associations (see documentation). However Rom is right to do it it two steps, it gives you more control.