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

[matbae]

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!

[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:

[Podoseb0 · Accepted solution]

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.

[matbae]

Thank you Podoseb0!