May 25 2022 02:17 PM
Hello All,
Suppose I have two files PQ1 and PQ2 and data in PQ1 and PQ2 are as follows:
Legal Name | Deal | Origination Date | Maturity Date |
TMT | D351 | 3/31/2016 | 3/31/2023 |
Deal | Legal Name | Origination Date | Maturity Date | Extended Maturity Date |
D351 | TMT | 3/31/2016 | 3/31/2022 | 3/31/2023 |
When I use PQ and merge I will get following result
Legal Name | Deal | Origination Date | Maturity Date | Deal | Legal Name | Origination Date | Maturity Date | Extended Maturity Date |
TMT | D351 | 3/31/2016 | 3/31/2023 | D351 | TMT | 3/31/2016 | 3/31/2022 | 3/31/2023 |
Now As you can see that extension has place so result that I actually want to see is:
Legal Name | Deal | Origination Date | Maturity Date | Deal | Legal Name | Origination Date | Maturity Date |
TMT | D351 | 3/31/2016 | 3/31/2023 | D351 | TMT | 3/31/2016 | 3/31/2022 |
TMT | D351 | 3/31/2016 | 3/31/2023 | D351 | TMT | 3/31/2022 | 3/31/2023 |
Could anyone advise how to get above result?
May 25 2022 11:26 PM
@Cmpunk The attached file contains a PQ solution that matches your example, though I suspect that your real life data is not as simplistic as you projected it. So, it might work at all in the real world at all.
May 26 2022 04:49 AM
May 26 2022 05:32 AM
Solution@Cmpunk Can't judge how the logic could be altered without seeing some real data. Many transformations in PQ can be done by just clicking the correct buttons, but at some point in time you'll find yourself needing to write or edit M-code in order to achieve more complicated goals. So, it's inevitable that you have to start learning about it.
May 26 2022 05:32 AM
Solution@Cmpunk Can't judge how the logic could be altered without seeing some real data. Many transformations in PQ can be done by just clicking the correct buttons, but at some point in time you'll find yourself needing to write or edit M-code in order to achieve more complicated goals. So, it's inevitable that you have to start learning about it.