Kiss the Krogan
New Member
- Joined
- Sep 19, 2019
- Messages
- 2
Hi everyone,
Long time reader, first time poster.
I have a Power Query (Main Verification Query) which collects data from a dozen spreadsheets, appends them into a table (TBL_Main_Append_Query), and each record has a unique ID. Unfortunately, the Unique iD is specific to each original spreadsheet, and does not run consecutively.
I have a second table (TBL_Verification) which has a data validation list looking-up the unique ID. This is where the data is validated by agents and comments are added in the Verification table. I have created a relationship between the two tables so I can query them together later.
When the query is refreshed, the data no longer aligns between the two tables (no surprises there). I need a code that compares the Unique IDs and inserts rows in the 2nd table so the two tables align the data based on the IDs.
Short of Power BI, I have reconfigured this numerous ways but can't seem to get it to do what I need. I think VBA is the only way for me to go, unless someone has a brilliant insight that I have missed!
If anyone can help, it would be greatly appreciated.
Thank you
KtK
Long time reader, first time poster.
I have a Power Query (Main Verification Query) which collects data from a dozen spreadsheets, appends them into a table (TBL_Main_Append_Query), and each record has a unique ID. Unfortunately, the Unique iD is specific to each original spreadsheet, and does not run consecutively.
I have a second table (TBL_Verification) which has a data validation list looking-up the unique ID. This is where the data is validated by agents and comments are added in the Verification table. I have created a relationship between the two tables so I can query them together later.
When the query is refreshed, the data no longer aligns between the two tables (no surprises there). I need a code that compares the Unique IDs and inserts rows in the 2nd table so the two tables align the data based on the IDs.
Short of Power BI, I have reconfigured this numerous ways but can't seem to get it to do what I need. I think VBA is the only way for me to go, unless someone has a brilliant insight that I have missed!
If anyone can help, it would be greatly appreciated.
Thank you
KtK
