Lists

Lists are a powerful option within Cohesive that should be used when you intend to extract an unknown number of rows or datapoints, such as from a table.

For example, let's assume that we wanted to extract the Name, Date, and Description columns for all of the rows in the Excel file below (in this example we can see it's four rows, but hypothetically let's assume it's an unknown or variable amount of rows)

To do so, we would set up a template in the following format

When exporting the above extraction to a CSV, it will result in a CSV export that has the name, date, and description columns, with four rows (one for each of the extracted data rows)

Even if you aren't sure how many rows exist, you can choose to run mathematical expressions based on each occurrence.

For example, let's say that we have four rows of data within a table called DataTable, each of which contain a number column calledAmount.

If we create a separate Math Expression field that has the formula of SUM(DataTable_Amount),this would return the sum of all of the Amount values (e.g., the sum of the Amount for all four rows).