Task
A supplier price list contains rows without a required value, for example without SKU. These rows must not get into the final CSV or XLSX.
Short answer
Open the sku column settings and add a row export condition: sku → Before transformations → Not empty.
How to Do It in Eofferix
- Open the settings of the
skucolumn.
The animation shows how to open the sku settings. - In Export conditions, add a row condition:
sku→Before transformations→Not empty.
The row is exported only when sku is not empty. In tables, this condition is applied to the whole row. - Save the column settings and continue to export.
Before / After
Before
source data| sku | name |
|---|---|
| SKU-100 | Office chair |
| Section header | |
| SKU-200 | Writing desk |
After
result| sku | name |
|---|---|
| SKU-100 | Office chair |
| SKU-200 | Writing desk |