Start reading from a specific line if condition is met

soncoku

Hello eveyone.

I'm working with some reports.

I thought we had only one format for these reports but apparently we have two formats.

One starts at line 9 and the other one starts at line 22.

i was thinking to solve it this way:

Read the first row 

If the first row = "Account Statement"

Start reading from line 9

else

If first row = "FC Transactions"

Start from row 22.

But I don't know how to convert that logic to Alteryx Code.

Can anyone help? 
Or if my way of thinking isn't right I'm open to alternative suggestions.

Zas3NfkB

You could try using a filter and sample tool. It would be easier to test with a full data set but this appears to work. 

ALteryx Solution.yxmd