Removing an Indeterminate Number of Rows

Patches

Hello all,

I get reports with a number of garbage rows before data actually starts.  The issue is, depending on the report the number of garbage rows will vary. However, there is a constant.  There's a cell under Field_1 with "Report Fields" in it, and this is the row directly before the field names for my data.

My current thought process is to search each row for "Report Fields" and remove any row before it.  Then I could use the Sample tool to remove the first record, and then get my correct field names.  

I attached two files to this discussion: the workflow, and some sample data.

I'm fairly new to the platform, so please let me know if there's anything else I can provide here.

Thanks!

Automating Report Cleanup.yxmd

Sample Report.csv

DataBlender

Welcome to the forum @Patches

I think you've already cracked it. Just put a filter after the multi row to exclude the nulls, skip the first row as you suggested and then use the dynamic rename tool to rename the columns automatically.