Terminate flow in warning

[Anastasio_Theohari]

Hello team,

I have a csv file and in the middle i found some errors.

An example below

ID         ITEM      DATE

44933  132         2020-06-13 18:53:59.397

74         701        1900-07-01 00:00:00.000
14.823

596      803         1920-01-01 00:00:00.000

The alteryx recognize the error as warning  as 'Not enough fields in record',but it continue to parse the input data in the output with no error.

I would like to ask how can i stop the flow and write only the correct data.

For example i would like to write the first 2 lines and then finish.

Is there any way to stop the flow in the first warning?

Thank you

[DavidP · Accepted solution]

You can use an if statement with a formula tool to determine the 1st row where data is incomplete, such as:

if isnull([ID]) or isnull([ITEM]) or isnull([DATE]) then 'Y' else '' endif

You can then use a multirow formula to mark all subsequent rows for removal and filter them out with a filter tool