Hi,
If those columns are string you can use data cleansing tool in order to achieve it.
@Mina2021
I think it is already dynamic, if you selecting all the columns.
So even your columns decrease or increase, it will still do the same.
Or you have other meaning by "Dynamic"?
Hi Qiu,
I want action fields to be dynamic, not the other fields. Actions fields are in even place and Date_diff fields are in odd place.
Hi @Mina2021,
I'd use a similar approach to @Qiu, however if you only want to affect certain columns you can utilize the [_CurrentFieldName_] field available in the multi-field formula tool.
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.
Kind regards,
Jonathan