I have a text file imported into Alteryx. I want rows below dashed rows to be labelled "S". I'm thinking of using the Multiple-Row Formula tool but not sure how to get it.
Example:
| Header 1 |
| --- |
| --- |
| Header 2 |
| --- |
| --- |
Output
| Header 1 | |
| --- | |
| --- | |
| S | |
| Header 2 | |
| --- | |
| --- | |
| S |