Skip rows till prefix is found (includes header row).
Example
In the below example, we are skipping until reaching the prefix "BBB" within the field "dim_B". 
Example Input
| dim_A | dim_B | metric_1 |
| AAA | ddd | 111 |
| BBB | eee | 222 |
| CCC | BBB | 333 |
Example Output
| dim_A | dim_B | metric_1 |
| CCC | BBB | 333 |
I Ain't Afraid of No Code!
[
[
"skipuntil",
{
"strict": true,
"keep_header": true,
"yield_match": true,
"subtable": null,
"prefix": "BBB",
"fieldname": "dim_B",
"_comment": null
}
]
]param boolean strict: Set to true if should raise an error when fields don’t exist.
param boolean keep_header: Original (first) header will be kept if true.
param boolean yield_match: Rows that already match the new value will be kept, and will otherwise be dismissed.
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str prefix: String up to which everything is skipped.
param str fieldname: Column to be searched for value.
param boolean yield_match: Row that matches value (=new header) will be kept, otherwise dismissed.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.