Hello all, I have a question about pivot. I created a pivot node, but there is a problem, it automatically removes duplicates, but it doesn’t do it the way I need. Is it possible to disable this feature, and if so how?
It will be helpful to see original data and expected result as well as node configuration.
At first I use csv reader node, than pivot and group column is Document_id. But there is a problem that, for example, I downloaded a file with the same Document ID. And after the pivot node I have only one duplicate file left, the one that was the first. But the problem is that I essentially need the last changed file, and unfortunately I myself have not found how to change the logic of work pivot node.