Forum Discussion
how to change values from one table to another
Capounet See if the attached file contains the PQ solution that works for you. It involves unpivoting each table first, then merge and expand and then add one custom column. Remove some columns and pivot again to come up with the desired result. It's all done by clicking in the UI. No complex M-coding required. It should not affect performance all that much on tables with 43 columns. But give it a try.
Capounet See if the attached file contains the PQ solution that works for you. It involves unpivoting each table first, then merge and expand and then add one custom column. Remove some columns and pivot again to come up with the desired result. It's all done by clicking in the UI. No complex M-coding required. It should not affect performance all that much on tables with 43 columns. But give it a try.
