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 |
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |