Support Synesty GmbH
Wie können wir Ihnen heute weiterhelfen?
How do i remove duplicates (get unique)?
2 KommentareSorted by Älteste zuerst
Synesty Support
gesagt
über 2 Jahre her
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.
Hey Support,
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?
Thanks,
Fabian
Gaurav Verma
I have a spreadsheet that contains price of a different item, i want to filter out all the unique prices in the list.
E.g.
Ids , Price
1, 12
2, 32
3, 12
4, 43
5, 11
6, 12
My desired output is
Price
12
32
43
11
1 Person hat diese Frage