Preserve column names when renaming dynamically without user input in analytic app

Dear Community,

I have created the following workflow within an Analytic app to dynamically let the user rename selected columns, see below.
It works as well as soon as data is entered via the GUI.

However, I would like the column names NOT to be renamed when no fields are being picked.

Currently, the columns are changed to RenameFieldToThisName1, 2 etc when there is NO USER INPUT, see screenshot.

Of course the workflow should still work as before when the user selects the fields for renaming in the GUI.

Any kind of solution is welcome, possibly through the use of filters?

THX!

Alteryx_Community.png

Analytic_rename - Test.yxwz

Input

Output

Apps

Help

Accepted answers

Podoseb0

You can pass the value from the Text Box tool directly to the Dynamic Rename tool by using the "Q" connector (the black one on top of the tools) and then add an IF statement like this:

IF isempty([#1])
THEN [_CurrentField_]
ELSE [#1]
ENDIF

[#1] being the text box input.

I'll attach the workflow as well. Let me know if it helps.

Analytic_rename - Test - rev.yxwz

All comments

DataNath

Hey @matbae if I'm understanding the request here correctly, would something like this work for you?

I've added a detour so that, by default, the app/workflow will run with the standard 'RenameFieldToThisName' rename:

Whereas, if the user selects that they need to provide input, this reveals the other options that I've nested inside within the Interface Designer, and they can then make the relevant changes:

Analytic_rename - Detour added.yxwz

Podoseb0

You can pass the value from the Text Box tool directly to the Dynamic Rename tool by using the "Q" connector (the black one on top of the tools) and then add an IF statement like this:

IF isempty([#1])
THEN [_CurrentField_]
ELSE [#1]
ENDIF

[#1] being the text box input.

I'll attach the workflow as well. Let me know if it helps.

Analytic_rename - Test - rev.yxwz

matbae

Thank you Podoseb0!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167