Dynamic Repalce Problem

[messi007]

Dear Alteryx Comunity,

I usually help people however I'm stuck with the dynamic formula tool.

It calculate only for the same formula when it change it display null

Please find attached the workflow.

I really appreciate your help 🙂

Regards,

[Qiu]

@messi007 
Wah, it is rare to see you on the other side.

After checking the samples again, I think it is here.

[Qiu]

Something is still wrong... the result is not correct...

[messi007]

Dear @AngelosPachis, @Emil_Kos,

Could you help me on this topic ! 🙂

Thanks @Qiu for the feedback I really appreciate you're help 🙂

Best Regards, 

[AngelosPachis]

Hi @messi007 ,

Thanks for tagging me, I will have a look at this as soon as I can.

Until then, there is someone in the community that I have seen providing a lot of help on this tool, so I will tag @danilang  in this post and maybe he knows the answer to this.

[messi007 · Accepted solution]

Hello Team,

Tanks for your help 🙂 

Below How I solved the problem.

1- Pass only one type of formula to the dynamic repalce using a filter and transform the workflow to macro batch

2- Update the macro config

4- Call the macro

It give the good result 🙂

Hope this helps!

Best Regads,

[danilang]

You beat me to it @messi007 

I was just about to post that the Dynamic Replace will apply all the formulas to all the rows in turn, so the formula in row 1 gets applied to rows 1-6, then formula in row 2, etc.  One at a time is the way to go

Dan

[Emil_Kos]

Hi @messi007,

Thank you for tagging me. I am happy that you have managed to sort it out.

I never used this tool(There are still a couple left in which I don't have much experience with and this is one of them). 😀

Still thank you once more for tagging and thank you to you I learned a thing or two as I needed to read about it in case you will ask me in the future 😉