Random results while renaming fields

[MelanieR]

Hi,

I built a workflow that aims to rename fields thanks to questions ask to the user.

Indeed throught list box tools, user is able to match the fields of his input with the "official" ones.

The problem is that when testing with different output (fieldnames modified), the results are differents. Indeed, according to the input file I am testing, all the fields are correctly updated or just some of them. I do not manage to understand what's wrong. I would really appreciate an help on that.

Please find the workflow and some inputs I used.

Please let me know if more details needed

Melanie

[fmvizcaino]

Hi @MelanieR ,

I'm sharing a workflow that is using the macro I sent you. The idea is to use as a tool in a workflow.

The yxmd file contains the yxmc file inside it. A yxmc file is a macro and works as a tool inside your workflow.

Let me know if this works for you.

Best,

Fernando Vizcaino

[MelanieR]

Sorry @fmvizcaino  I was looking for something much more complicated. Then I though components were missing in the workflow you've sent previously.

I am gonna try and let you know.

Thank you for your help!

[fmvizcaino]

Great @MelanieR !

Let me know if you need further assistance

[MelanieR]

Hi @fmvizcaino,

Your idea was interesting but I think it cannot fit to what I need to achieve.

Indeed input files can have different number of fields.

Then the renamed fields in the macro would not necessary match with the field of the input. And If I set up all the possible fields into the macro it gives me an error when testing because all fields need to be mapped.

Thanks anyway.

Melanie

[MelanieR · Accepted solution]

Hi @fmvizcaino, @GiuseppeC 

I found what was the issue.

The Alteryx version I used was a french one and it seems that there is a bug.

Indeed I unsintall it and install the English version and I can see that the set up of my 'Dynamic rename' tool was not ok. As you mentionned @fmvizcaino  'Dynamic or Unknow Fields' boxes were not checked on all tools (boxes that I saw checked with the french version). I correct it and know it's working properly.

Then I am gonna keep working on english version.

Thanks to both of you for your help.

Melanie

[GiuseppeC]

Thanks for the feedback, @MelanieR!

Giuseppe