Forum Discussion
Power Query Help
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.
Riny_van_Eekelen Thank you for your mail .
For 215,315,307,258,336,190,420,506,151,232,541- Row Bifurcation is incorrect. Example for 215 correct output is
11/13/2015-3/31/2021
3/31/2021-4/30/2021
4/30/2021-12/31/2022
Output as per sheet
3/31/2021 3/31/2021 4/30/2021 4/30/2021 12/31/2022 12/31/2022 For 506 Correct Output
8/6/2019-3/1/2022
3/1/2022-3/11/2022
3/11/2022-12/31/2022
Output as per sheet:
8/6/2019 3/11/2022 3/1/2022 12/31/2022 3/11/2022 12/31/2022 For 173- One of the row is missing
Correct Output:
6/1/2015-12/23/2023
12/23/2023-12/23/2024
Output as per sheet:
6/1/2015 12/23/2023 I tried tinkering with the formula but to no avail. Any suggestion will be appreciated?