Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic field name in table tool

amiranis89
5 - Atom

Hi,

 

I'm working on a analytics app where I take inputs from user and parse it as field names using dynamic rename tool. Then select few specific of fields in table tool (reporting). Due to dynamic names, I ran into error of missing fields.

 

Is there any work around for dealing with dynamic name fields in Table (field select section) tool and Select tool?

Like position based selection?

1 REPLY 1
pedrodrfaria
13 - Pulsar

Hi @amiranis89 do you have the Dynamic and Unknown Fields checkbox checked? That should avoid you having this error.

 

You could also do a logic of applying the dynamic select to the table tool as well. So you then be updating in the beginning of the workflow and at the end.

 

A different thing you can do is use fixed names, so dynamic select those fields and at the same time dynamic rename them to the name of the fields you use in the workflow, so you won`t have a missing fields error anymore.

 

If possible, upload a sample workflow.

 

Pedro.

Labels