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.

[Thableaus]

Hi @soncoku 

Here's a way of doing this (attached) - you might need to adapt to your condition.

I tested in both cases (Account Statement and FC Transactions) with different line starts and it seems to work.

Cheers,

[Zas3NfkB · Accepted solution]

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.