Normalizing data - insert/update to sql

[Hamder83]

Hi 

As an example I want to take a flat table and split into 3 different dataset.
Each for these dataset needs to be inserted into 3 different sql tables, with id's from the parent table.

This is a simple invoice:

Tracking number 
Creditor
ShipmentYear 
Invoice Number
Invoice date,
ShipmentPrice
ShipmentServices
Curerncy 


I want my base data to be
Table 1:
id (pk), CreditorNumberUB, ParcelNumberPurchase, ShipYear, BookingLineId

Table 2:
id (pk), FilePeriod, InvoiceDatePurchase, InvoiceNumberPurchase, ParcelNumbers_id


Table 3: 
id (pk), InvoiceDetails_id, AccountNumberPurchase, CalcWeightPurchase, CurrencyPurchase, Direction, NoOfParcels, PriceZonePurchase, ProductCodeUB, ReceiverCountry, SenderCountry, ServiceAmountPurchase, ServiceCodeUB, ShipmentDatePurchase

My struggle is, I can ofcause summarize my parcelnumbers, and add/update them into the sql. But I want my table 2 to inherit the id from table 1. And same goes for table 2 and 3.

But how do i do that in 1 flow? 

I have been trying to weeks to find a good solution, but it does simply not give me the result I need.

if anyone wants to give an example of how you would do it?