Forum Discussion
Imported data not aligning with manually entered data in table
ScrubNurseTracey It's not really all that simple. You need to include a step that joins the stock list you connect to with the table that contains the edits.
The attached file demonstrates this. I trust that you can follow the applied steps. If not, come back here.
Riny_van_EekelenHelloooo,
Thank you so much for helping!
So, i'm attempting the steps which make sense, however....
how on earth did you create source2??? there is no additional table in the sheet (you cant load the final query into a table) and there are no add column steps for you to have added the no./ask/ha columns through query edit either. I am perplexed.
Another thing is I cant see which queries were loaded or connection only so i am trying to guess. As the result after merge is a single query on it's own.
I believe I should have it sorted once I know the above.
I am very appreciative!
Would it really be too much for excel to bring out a 'group individual data rows in table' button
ScrubNurseTracey Perhaps difficult to explain but first you just connect to the blue table and load it back to Excel. That will become Source2, the green table. Now you can add the manual columns. Next time around the original data connection (the blue table) will be updated, indexed and merged with the now expanded (green) table. It's a bit awkward to begin with but it does work.
By the way, the Source2 step is added in the Advanced Editor, so it's not added by pushing a button. The same applies to the merge step. You first merge the query with itself to get the basic code and then you have to edit the M-code to merge the table from the "previous step" with the table from step "Source2". Again, not easy to grasp at first, but it does work.
- OHHH, I'm a nurse so if it's not selecting options or using sum, vlookup or filter, than I'm never sure how to complete the formulas in the right way.
Yes i was wondering how you had another source without a merge step.
I do not know what an M-code is haha.ScrubNurseTracey Can only feel sorry, because I can't help you any further. It does take an effort to learn these things and can imagine you're not really in to it (yet).