Fill in blank from duplicated fields

knozawa

Hello,

I have an input that contains "duplicated" fields.

Using a dynamic rename tool to replace desired field names.

find replace.png

"duplicated" fields were renamed to [column1]+digit.

after dynamic rename tool.png

Here is the desired output.

desired output.png

I would like to dynamically fill in blanks. I've tried to use "multi field formula" tool and "multi row formula" tool, but could not successfully achieve desired output.

I've attached a sample workflow.

Sincerely,

knozawa

Fill in blank from duplicated fields.yxzp

Tips and Tricks

Common Use Cases

Best Practices

Transformation

Dynamic Processing

Accepted answers

Jonathan-Sherman

Hi @knozawa,

I've made a slight ammendment to the piece of regex and dynamically fix changes in column headers after the cross-tab:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed,

Regards,

Jonathan

20200203 - FillBlanks.yxmd

All comments

JosephSerpis

Hi @knozawa I mocked up a workflow that I believe answers your question let me know what you think?

Blanks_03022020.yxmd

knozawa

@JosephSerpis ,

Thank you for your suggestion. It works fine for fields that do not contain integer. I apologize that I did not specify that sometimes there are integers in the fields (i.e. "past 5 years").