Good Morning All,
I have a data import where I need to ignore some rows, then capture some rows, and then capture some rows again for some further data analysis (using select I can run various paths for each column once split)
I have been able to identify the header rows (which are identical) where I need to break, and I know I can delete everything above the first header row, but how would you extract out the data beyond this? The number of rows varies sadly.
Thank you
Example data:
| Data | Headers Flag |
| Data String to be Ignored | 0 |
| Data String to be Ignored | 0 |
| Data String to be Ignored | 0 |
| This is my header row | 1 |
| Data String to be processed now | 0 |
| Data String to be processed now | 0 |
| Data String to be processed now | 0 |
| Data String to be processed now | 0 |
| This is my Second header row (its identical to first header row) | 1 |
| Data String to be processed Later | 0 |
| Data String to be processed Later | 0 |
| Data String to be processed Later | 0 |
To This:
| This is my header row | This is my Second header row (its identical to first header row) |
| Data String to be processed now | Data String to be processed Later |
| Data String to be processed now | Data String to be processed Later |
| Data String to be processed now | Data String to be processed Later |
| Data String to be processed now | |
Thank you
