Power Query Help

Question

I have following data&nbsp;Legal NameFacilityLIQ Origination DateLIQ Maturity DateAdjusted Origination DateAdjusted Maturity DateMM12/28/20178/31/20228/31/20228/31/2022KO23/5/201412/31/20236/30/20206/30/2021KO23/5/201412/31/20236/30/202112/31/2023MD312/29/202112/29/202612/29/202612/29/2026&nbsp;However I want result in following format&nbsp;Desired OutputLegal NameFacilityLIQ Origination DateLIQ Maturity DateAdjusted Origination DateAdjusted Maturity DateMM12/28/20178/31/20222/28/20178/31/2022KO23/5/201412/31/20233/5/20146/30/2020KO23/5/201412/31/20236/30/20206/30/2021KO23/5/201412/31/20236/30/202112/31/2023MD312/29/202112/29/202612/29/202112/29/2026&nbsp;or&nbsp;There is some error in my working . I am attaching my working .Could anyone advise how to get desired result?

riny_van_eekelen · Answer

Cmpunk&nbsp;Have a look at the attached file. I added another query Merge2 that seems to produce what you asked for.&nbsp;

riny_van_eekelen · Answer

Cmpunk&nbsp;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.&nbsp;

riny_van_eekelen · Answer

Cmpunk&nbsp;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.&nbsp;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.

riny_van_eekelen · Answer

Cmpunk&nbsp;Again, I can not work on a file that connects to something on your own system. So, I copied the data for 117 and 370 into my own file. 173 was already there. Then I refreshed my query.On 117, note that your data contains three identical rows:The query only picks-up one row and the end-result includes only one row.&nbsp;On both 370 and 173, the end-results looks like this and I believe it follows the same logic as all the other ones. So, I don't really understand the problem.&nbsp;&nbsp;&nbsp;

cmpunk · Answer

Riny_van_Eekelen&nbsp; 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.

Forum Discussion

Power Query Help

Share

Resources

MM	1	2/28/2017	8/31/2022	8/31/2022	8/31/2022
KO	2	3/5/2014	12/31/2023	6/30/2020	6/30/2021
KO	2	3/5/2014	12/31/2023	6/30/2021	12/31/2023
MD	3	12/29/2021	12/29/2026	12/29/2026	12/29/2026