Replace Null values with nearest left field and combine headers
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you post your sample data as a table or attachment, instead of an image?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Of course. A sample is attached.
Thanks for your reply
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's working. Had to edit the workflow a little bit because of my real data but it's working.
Thank you very much!
