I hope someone can help me with this.
I am attempting to pull and merge/union a number of datasets based on another list of ID'sSo the first query would be something like the following:
This gives me my list of id's:
I need then to loop through and make calls to the webservice based on the ID:
and union it all together as unfortunately the webservice doesnt have a call for give me all absensces for everyone.Any help, guidance or ideas on this would be much appreciated as I am relatively new to power query and not to sure where to start with this.
Go to Solution.
so add a new column to your id-Table where you calling this webservice like you did in you last post. Substitute the "ID"-part with the column reference as I was showing in my previous post.
Then you should get a table in every cell of your new column. Then you can combine this table-column with Table.Combine(YourPreviousStep[YourNewColumn])
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)Kudoes are nice tooHave funJimmy
View solution in original post
you can add a new column where you making the data access and use the ID of parameter of it lik
Web.Contents("httpxxxxxxx/" & _[ID] & ")")
Depending what this web service is handing over, you can combine the results like
Combine = Table.Combine(YourPrevisousStep[YourNewColumn])
Thanks for your reply @Jimmy801 .
Apologies though, I'm new to this language and don't really understand what you mean.When I make the call to the webservice with the ID included i get the following back:
So I need to make that call for each uniqueID from the initial request and union them.
Thanks for that.This is what I have ended up with, while it might not be the best its working and I can tweak as I learn more
Thanks for the help and the extra explination @Jimmy801
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021