This node allows you to filter out rows that have common data values for the chosen columns. The output data from this node will contain distinct rows.
- Output Data Columns section allows you to analyse what input data columns are incomming into the node. Here you can also multi select the columns you will like to choose for the distinct columns.
- Distinct Columns section displays the columns that will be examined if the input data rows will be passed onto the output. For each selected distinct column, no row in the output will have the same data values as the chosen distinct columns.
NOTE: Depending on how many rows are present in the data and how many distinct columns are chosen, the processing of this node may take some time.