Hello,
Can someone help me please solve my problem?
I have one import file that I need to split into two halves and somehow achieve that after the first half is loaded it will "hold in variable" autogenerated ID and with this ID create new rows in my next table.
Let me explain it on example
Import Data - Peter, Days: 1.1-3.1.2023
1st step: import this exact row into Table 1
Table 1: ID 1, (autogenerated ID), Peter, Days: 1.1.-3.1.2023
2nd step: know that for this row the ID was generated as 1 in Table 1 and import data in table 2 under ID 1
Table 2: ID 1, 1.1.2023
ID 1, 2.1.2023
ID 1, 3.1.2023
Hope my explanation make sense,
Thank you!
