Renaming & Adding Fields at the same time

[tflorkiewicz]

Hi all,

So I have some combined reports I need to rename all the fields of based on a field name mapping table. I realize the dynamic rename tool is perfect for this, but it only adds the fields that can be mapped, and drops any other field names. If my initial data has 11 fields, but my mapping table has 25 field names, is there a quick way to map the 11 and also add the remaining 14 at the same time?

My current solution is to take the unused field names, cross tab them into a row, set the values below them to null, and then appending to the original data with the renamed column to add the remaining columns... (I included a snippet of the workflow below)

I realize this is a bit of an abstract case, but the final output needs to have all 25 fields, not just the 14 that I have data to populate.

Thanks for any help!

[Ladarthure]

Hi @tflorkiewicz, one way to do it would be to use a union with your field map (new column names) with a dummy row you could filter after. The use of the corss tab is a good trick to do it.

If you have sample data I could give it a look.