Replace Null values with nearest left field and combine headers

sebastianlauss

Hello everyone.

Can somebody help me how i get these Headers like in "Target"

I get my data through Excel and these Headers are combined cell therefore there are this many NULL fields.

Dynamic Rename is no option, because this sheet has like 1000 coloumns with over 50 headers.

The simpliest way may be the replace the NULL values with the value from the nearest left field. But I don't know how.

Thanks for your help!

Sample Data.xlsx

ChrisTX

The attached workflow should give you a good starting point. 

The Dynamic Rename tool has several options under the Rename Mode dropdown.  In the Developer tab, when you click the Dynamic Rename tool in the ribbon, click the link for Open Example.  Then run the example workflow and review the various outputs.

The challenge with a layout like this is that you'll need to use the Input Data tool option for "First Row Contains Data", which imports all fields as data type V_String.

You can use the Auto Field tool to change the data types.  But I try to avoid data type Double whenever possible.

Chris

Replace Null values with nearest left field and combine headers.yxmd