I have a spreadsheet that contains price of a different item, i want to filter out all the unique prices in the list.
Ids , Price
My desired output is
Hi Gaurav Verma,
you can use the group by column function of SpreadsheetMapper step (Settings -> Group by Column name, Select your price column). The result spreadsheet contains rows with unique prices.
I tried your solution, but unfortunately I always get the following error message:
Max. Anzahl Zeilen 2000000 für die Gruppierung überschritten. Bitte reduzieren Sie die Anzahl Zeilen im Quell-Spreadsheet.
I have 8 Mio rows in total in the source csv and I want to reduce it to a reasonable amount. Is there any other way to get around this grouping limitation?