RogerPenna
New Member
- Joined
- Mar 27, 2017
- Messages
- 20
Hi everybody.
So, we have these tables with
-Contract Numbers
-Date
-Service Description
-Quantities
We have this legacy table that has 16 thousand rows, for 3 years of contracts, with several services per month per contract.
We need to keep this Legacy Table data, but we want add data from files that will be put in a folder... each file corresponding to the services of a single month of a single contract (yes, it's stupid, but that's because how the Export from a legacy program we have work)
So, the inclusion of files in a folder, and them becoming a single table already works. I made several transforms, so PowerQuery gets the date and contract number from the header of the files and create columns for them, etc.
And then I have this other table with 16 thousand rows with legacy data.
I want to create a merge where I will have the old legacy data AND the new data being inserted montly in the folder.
But no merge I try gives me the wanted result, which is to get the LEGACY DATA table, ADD new ROWS (not columns) if they don´t exist, and UPDATE VALUES of old rows, if they have changed.
So, we have these tables with
-Contract Numbers
-Date
-Service Description
-Quantities
We have this legacy table that has 16 thousand rows, for 3 years of contracts, with several services per month per contract.
We need to keep this Legacy Table data, but we want add data from files that will be put in a folder... each file corresponding to the services of a single month of a single contract (yes, it's stupid, but that's because how the Export from a legacy program we have work)
So, the inclusion of files in a folder, and them becoming a single table already works. I made several transforms, so PowerQuery gets the date and contract number from the header of the files and create columns for them, etc.
And then I have this other table with 16 thousand rows with legacy data.
I want to create a merge where I will have the old legacy data AND the new data being inserted montly in the folder.
But no merge I try gives me the wanted result, which is to get the LEGACY DATA table, ADD new ROWS (not columns) if they don´t exist, and UPDATE VALUES of old rows, if they have changed.
