Neues Thema starten

How do i remove duplicates (get unique)?

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

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.  


image



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

Anmelden um einen Kommentar zu veröffentlichen