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
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.
Rom van Arendonk
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.