Alteryx Designer Desktop Discussions

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

Dynamically select fields based on condition

knozawa
Bólido

Hello,

 

I would like to dynamically select fields based on conditions.

 

If there is a "New Email" field, then select "New Email" field and do not select "Email" field.  If there is no "New Email" field, then select "Email" field instead.  Similarly, if there is a "New Phone" field, then select "New Phone" field and do not select "Phone" field.  If there is no "New Phone" field, then select "Phone" field instead. 

 

The tricky part is that sometimes there is no "New Email", "Email", "New Phone" or "Phone" fields.  In this case, there is no field to select.  When I was trying to use the dynamic select tool by using formula contains([Name],'New Email'), I got an error message Dynamic Select (50): RecordInfo::CreateRecord: A record was created with no fields.

Does anyone know how to dynamically select fields based on conditions?

 

Sincerely,

knozawa

2 RESPUESTAS 2
Inactive User
No aplicable

Solution attached.

knozawa
Bólido

@Inactive User,

 

Thank you very much!

I've chanced the cross tab configuration and it worked well.

Cross tab configuration.png

Sincerely,

knozawa

Etiquetas