CODEWITHSUNDEEP
azureetlazure-data-factory
Garreth
Garreth

Reputation: 1095

Altering CSV Rows in Azure Data Factory

I've tried to use the 'Alter Rows' function within a Data Flow in Azure Data Factory to remove rows that match a condition from a CSV dataset.

The Data Preview shows that the rows matched will be deleted, however in the next step 'sink' it seems to ignore that and writes the original rows to the CSV file output.

Is it not possible to use alter rows on a CSV dataset and if not, is there a work around?

Upvotes: 0

Views: 1113

Answers (1)

Steve Johnson
Steve Johnson

Reputation: 8660

Firstly,use 'union' to migrate your csv files as source.

Then,use 'filter' to filter your data with date time stamps at source.

Upvotes: 1

Related Questions