I am a first time user of STICH and I’m currently amazed by how easy to use it is …only until i found an issue
I’m trying to ETL data from Xero Accounting to a PostgreSQL. So the first time trying, I try to replicate 1 table and hit the issues that cannot be solved or got a clue why
Here is the problem:
- I chose only 1 table (invoices) to extract from source
- It ends up in 7 tables in the Destination ( Invoice __lineitems…,etc …)
- There is no Primary key for me to link/join these tables (at least I dont know how and which one).
You may see the picture for your reference.