Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Alteryx Designer Desktop Discussions

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

Dynamically select fields based on condition

knozawa
11 - Bolide

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 REPLIES 2
Inactive User
Not applicable

Solution attached.

knozawa
11 - Bolide

@Inactive User,

 

Thank you very much!

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

Cross tab configuration.png

Sincerely,

knozawa

Labels