Random results while renaming fields

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

FieldsRenaming.yxmd

Outpout_TestFile1.csv

TestFile1.csv

Outpout_TestFile2.csv

TestFile2.csv

Workflow

Apps

Help

Preparation

Interface Tools

Accepted answers

MelanieR

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

All comments

fmvizcaino

Hi @MelanieR ,

I have a few questions about your process.

1. Will this workflow be uploaded to server?

2. Is it possible for the file not to have all columns?

3. The idea is to rename all columns to the ones suggested, right?

Best,

Fernando Vizcaino

MelanieR

Hi @fmvizcaino ,

Please find my answers below:

1) Not sure yet on that point.

2) The principle is that all source files (then data flow) can have a different structure (different fieldnames and different field positions).

3) And you're right, the idea is to rename all columns of the input with the ones suggested.

Melanie

GiuseppeC

Hi @MelanieR,

Hoping that I was able to understand the problem correctly, I think the issue is in the configuration of your Dynamic Rename tools. In particular, you will need to check the Dynamic or Unknown Fields box to solve it (see below). If you leave it unchecked, as it is now in your current workflow, effectively at run time the formula is not being applied to any of the fields.

Hope this helps!

Giuseppe

MelanieR

Hi @GiuseppeC,

Thank you for your feedback. The "Dynamic or Unknown Fields" box is already checked on my workflow. It might be unchecked when installing or because we using different versions of Alteryx. Strange.

Thanks anyway for your time!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703