Jul 09 2020 10:20 AM - edited Jul 09 2020 12:41 PM
Hey all.
I've created a power query (fetching and parsing a JSON)
-> It fetches a subset of records form a website.
I have a worksheet with all possible records that could be coming in. I've made it a table and imported it into power query.
But when i try to combine the two sources: the merge window opens, i can select both queries, but then i cannot press 'ok'; it's grayed out.
Workaround 1:
Also making a connection between the 2 in relations manager makes a 1-to-many connection, even though BOTH recordsets are unique rows on the field i want to match, and i've made both the same name too. => workaround using 'related' won'r work
Workarround 2:
My next workaround was to do the final combines via a lookup statement in power pivot.
After some headaches, i managed to get that working, but the Calculated columns will not show up in the original power query output (on the sheet)
How can i do that last bit?
(or get the merge to work to do it in powerquery, my preferred choice.
Thanks!
Example data:
Full set:
aaa ccc askmefff
111 333 askmefff
222 444 askemefff
444 666 askSomeoneelse
333 666 askSomeoneelse
666 999 askSomeoneelse
Partial set
1 2 3 4 5 askemefff
4 3 2 1 askmeff
8 2 6 2 askSomeoneelse
EDIT: Found out i missed a step; it's not very obvious you have to click on columns in both to 'connect' them. Done and it does work.;) (when you see the 'previews of both tables, click on the column that;'s the same for both).