Forum Discussion
How to prevent PQ filling down rows
I have a two files I am merging and once I expand and bring in the columns from the other table PQ will auto duplicate the rows for those new columns and insert the values.
So if I have the following table, I merged the Type and Projection table so that I could include the Lot column. However, it duplicates the projection numbers that are associated with the Type. I want those to be null values instead or somehow get the merge effect of a cell like you would have in Excel. Any ideas?
| Type | Lot | 1 month projection | 2 month projection | 3 month projection | 4 month projection |
| Blue | F5557 | 3 | 3 | 6 | 7 |
| Blue | W2222 | 3 | 3 | 6 | 7 |
| Red | GH222 | 4 | 8 | 8 | 8 |
| Red | G8999 | 4 | 8 | 8 | 8 |
1 Reply
Hi JJBB ,
This looks like an XY Problem waiting to happen.
Can you give a bit more detail around what these different fields represent, and also give an overall view of what you're unltimately trying to achieve please?
Pete
