.. _auto_dataset_column_to_csv:

*DATASET COLUMN TO CSV*
=======================

Takes a dataset and a single column name and returns that column's values as a delimited string (CSV by default). Use it to feed a column into an input that expects a comma-separated list -- e.g. a column of ids/values into another worker, or a column list into ml_learn_auto independents_csv / clabel_csv.

When to use
-----------

Tagged: ``column``, ``csv``, ``dataset``, ``extract``, ``list``, ``pluck``, ``values``.

Inputs
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset
     - dataset
     - dataset
     - —
     - ✓
     - Input dataset (flat array of rows) to read a column from.
   * - Column
     - column
     - select
     - —
     - ✓
     - The single column whose values are returned as a delimited string. Populates from the connected dataset's columns; you can also type the column name.
   * - Delimiter
     - delimiter
     - text
     - ,
     - 
     - String placed between values (default ',').
   * - Unique Only
     - unique
     - select
     - no
     - 
     - When yes, duplicate values are removed (first occurrence kept).
   * - Skip Empty
     - skip_empty
     - select
     - no
     - 
     - When yes, empty/blank cells are skipped instead of emitted as empty entries.

Outputs
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - Label
     - ID
     - Type
     - Description
   * - CSV
     - csv
     - string
     - The chosen column's values joined by the delimiter.
   * - Values
     - values
     - dataset
     - The chosen column's values as a one-column dataset (each row { value }).
   * - Count
     - count
     - integer
     - Number of values emitted.
   * - Status
     - status
     - string
     - Human-readable summary (or the available columns when the column was not found).

Disciplines
-----------

- data.dataset.transform

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>platform</code> schema. Worker id: <code>dataset_column_to_csv</code>. Schema hash: <code>b2b7eaba8e31</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>