Creating a database model from an excel file without manual actions

By Fred Stoopendaal on 13 Jan

I like to create a model from an Excel file.

I have for example the following Excel:

Sheet1: (name: Order)

Id
Name
1
Order1
2
Order2


Sheet2: (name: OrderLine)

Id
OrderId
Name
1
1
art1
2
1
art2
3
2
art1


When I import this Excel I get 2 not related tables with the Id renamed to Id2 and with a new Id added.

I know, I can remove the new Id and rename the Original Id back to Id, and than change the data type of OrderId to Order Identifier.

I want that if the first column in Excel is called "Id" outsystems don't create an extra Id. And that if a column is named "OrderId" it will be linked to "Order.Id".

For me this is a nice extension of the import Excel functionality.

Regards,

Fred.

This idea has no comments yet. Be the first to comment!