Forum Discussion
Power Query Help
I have following data Legal NameFacilityLIQ Origination DateLIQ Maturity DateAdjusted Origination DateAdjusted Maturity Date MM 1 2/28/2017 8/31/2022 8/31/2022 8/31/2022 KO 2 3/5/20...
Cmpunk Have a look at the attached file. I added another query Merge2 that seems to produce what you asked for.
Riny_van_Eekelen Thank you for your response. I tried your solution on my sample data unfortunately it is not giving desired result. Could you advise? I am attaching file for your reference.
Cmpunk But you didn't use the same query. I note you don't have the "Remove Duplicates" step, for instance. May I suggest you copy your "real" data into the relevant tables in the file I sent. Not changing any table or column names. Don't have time to that myself right now, sorry.
Riny_van_Eekelen Thank you for your response. I understand your thoughts. Your solution is flawless but for some of the securities, solution is not working. Whenever you have time kindly guide me. The securities are part of the same dataset so solution would work for all the securities.
Cmpunk Sorry, but the data in the file you attached is not resembling the date I had based my queries on. The first table is OK but the second one doesn't have the columns needed to achieve what you described earlier.
Furthermore, you wrote that it worked for most but not all. Your file links to workbooks on your own machine and I can only guess that the tables in Sheet1 represent what's in these workbooks. But maybe, they don't. If they do, I suggest you connect the queries to these tables, load the Merge query back to Excel and explain what's wrong and why.