Dynamic rename issue in 10.1

Hi All,

I have my workflows created in 10.0.8 and till that version, when we use "Take field names from first row of data" in dynamic rename, if two columns have the same data, the second column will be created with incremental numbers and underscore before that. But in version 10.1, it is not creating the new field names with underscore in it. Is that an expected behaviour or a bug?

Example,

If my data is,

Field1 Field2 Field3 Field4 Field5

0 1 0 1 Total

1 2 0 1 Total

Output in 10.0.8 is

Field names --> 0 1 0_1 1_2 Total

1 2 0 1 Total

Output in 10.1 is

Field names --> 0 1 01 12 Total

1 2 0 1 Total

Thanks in advance,

Jeeva.

Preparation

Accepted answers

s_pichaipillai

seeems its strange,

Alteryx released a patch

http://community.alteryx.com/t5/Engine-Works-Blog/Alteryx-10-1-Patch-Release/ba-p/10793

can you applly this and try to reproduce this issue?

fadib

Hello all,

To round off the request, I'll give a summary of the issue and the solution.

There was a change in the behaviour of the Dynamic Rename tool between releases 10.1.6.60263 and 10.1.6.11313 where by:

10.1 Minor Update - Release date January 14, 2016, version 10.1.6.11313
Underscores are no longer omitted for single digit integer (0-9) duplicate field names. For example, a duplicate for field name "5" is now properly named "5_2".

This change was causing the difference in output depending on which Alteryx version the workflow is run on.

The solution is to upgrade to 10.1.6.11313 to get a consistent output and have the underscore for duplicate Numeric field names.

Best wishes,

Fadi

All comments

s_pichaipillai

seeems its strange,

Alteryx released a patch

http://community.alteryx.com/t5/Engine-Works-Blog/Alteryx-10-1-Patch-Release/ba-p/10793

can you applly this and try to reproduce this issue?

jeeva_ganesan

Not sure what setting in alteryx is causing this. We both moved to the same version and applied the patches as well. Issue persists..

fadib

Hello all,

To round off the request, I'll give a summary of the issue and the solution.

There was a change in the behaviour of the Dynamic Rename tool between releases 10.1.6.60263 and 10.1.6.11313 where by:

10.1 Minor Update - Release date January 14, 2016, version 10.1.6.11313
Underscores are no longer omitted for single digit integer (0-9) duplicate field names. For example, a duplicate for field name "5" is now properly named "5_2".

This change was causing the difference in output depending on which Alteryx version the workflow is run on.

The solution is to upgrade to 10.1.6.11313 to get a consistent output and have the underscore for duplicate Numeric field names.

Best wishes,

Fadi

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703