Hi,
Please help on the below issue.
In power Query, I have two workbook queries and I need to transfer the related match column data from one query to another query data.
How to insert the formula column in the query for Lookup.
Thank u.
Hi,
Please help on the below issue.
In power Query, I have two workbook queries and I need to transfer the related match column data from one query to another query data.
How to insert the formula column in the query for Lookup.
Thank u.
Use the "Merge Queries" function, and choose the matching column in both tables.
The M code will look something like:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Dear Mr. Olly,
Thanks for your information.
But I did not find my output. I hereby attaching the files what I need with detailing. Can you please convert that requirement in power query in excel file.
Thank you.
Hi,
Can I get the solution for the above message along with attachments.
Try this:
You may need to change the data type of [RES No.] in query "Append1":Please Login or Register to view this content.
Please Login or Register to view this content.
The logic works in a slightly diffferent way to your PDF - we unpivot first, then look up the values returned to find the Code - then we can simply do a count of rows, with the appropriate grouping.
Hi,
Its working and I got it.
Thank u very much.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also 'Add Reputation' to those who helped you. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks