Dynamically change NULL to 0.00% for varying column names; and Dynamically change header

[vivaisun11]

Hello.
I have a dataset that refreshes each week.

There are certain weeks where I may not have any data and during these weeks, I need the final output to show 0.00% instead of NULL.

The column names, which have the Week No. change each week so I am unable to use the Cleansing tool since it keeps unchecking the week numbers as I run the flow the following week. Similarly, the multi-field formula isn't working since the column names are changing in each week.

I would also like to add "WEEK NO." in the header for each week, as the weeks change.

Any suggestions on how I can go about these?

Thanks!!

[binu_acs]

@vivaisun11 The multi-field tool formula should work if you select the Dynamic or Known field option selected

[SIDDINATHAM_HARISH]

this is correct i was tried and exactly get the same answer, when datatype is in string so we can use '0.00%' then it works i have also done same