Copy Field and create two mor fields with it

[Rico_Widmayer]

Hi community :) 

I am facing an issue I could not solve so far. 

I am trying to find a dynamic way to copy existing fields in a specific structure. 

Input: I have a file that contains two fields with "Name" and "Status". After that some values are followed, whereas the field names are monthly dates. Those values are quarterly values and therefore only available in January, April, July, October. I would like to fille the empty fields of e.g. February and March with the Janaury values. May and June with the April values etc.

Name	Status	01.01.2022	01.02.2022	01.03.2022
Jon	Ready	100	should be "100"	should be "100"
Toby	Ready	200	should be "200"	...
Jake	Ready	123	should be "123"	...

I could solve it via formula tool. The problem is I am having a range from January 2000 until December 2032. And those dates are changing every year (start will for example change to January 2001). Only the general strcuture stays consistent: It always starts with the field containing a value and is followed by two empty fields that should contain the same value. 

[KSowers · Accepted solution]

This should work for you. If this works, please mark as a solution! If not, let me know how we can edit it!

[Felipe_Ribeir0]

Hi @Rico_Widmayer 

One way of doing this

[grazitti_sapna]

Hi @Rico_Widmayer , The transform tools will do the magic and provide you the desired resultset. I have shared the workflow on the input you have provided. Let me know if you need any other help.

[RogerS]

the attach workflow will do this dynamically and fill in the missing fields.  Please accept as solution if this works.