Forum Discussion
Imported data not aligning with manually entered data in table
I would like a table with 2 manually entered data columns and 1 imported data column as shown: The imported data (just a single column table of data with the stock items) is the middle column:...
Yes, manually added data is not in sync with one returned by Power Query. You need to query table with manually added columns again, merge with source and return result on the same place. Technique is described here Self Referencing Tables in Power Query - Excelerator BI
- Thank you, I did see you personally reccomend this to someone in my searches.
I read it, tried to do it, but you can't add data after you have created the connection as it kept wiping any new data I entered when you refresh.
This would work if I didn't need to keep adding data.That's exactly the same method as Riny_van_Eekelen demoed in his sample, all shall work if you build the query correctly.
- Hello,
I completed all steps in the link. I have just done it again a 2nd time.
If i was to sort the items, yes they do stay together.
HOWEVER, when i add a new stock item to the source data and refresh my connections,
The data will no longer be aligned where it is meant to. This is why I couldn't continue with this method the first time.
I promise I did every step twice now, exactly as listed. It does not work when adding new items to the source data.
