Alteryx Designer Desktop Discussions

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

Missing field in Select tool but it appears in the Union tool prior to Select

CherieACI
8 - Asteroid

We have a field 'Company' that is disappearing from the select tool even though you can see it coming into the select tool from a previous union tool. We have double checked each file in the directory to make sure there is a column with the name 'Company' and all files do contain that column name. Why would this happen? 

 

The workflow has been run, saved, closed, opened and we have exited Alteryx and came back in with no success! Please see screen shots below:

Union tool:

CherieACI_0-1626359512653.png

Connection: 

CherieACI_1-1626359554575.png

 

Incoming select tool where Company disappears in the list but shows in the results at the bottom:

CherieACI_2-1626359606802.png

 

Outgoing select tool 'Company' has disappeared in both the list and the results and there should be 48 fields: 

CherieACI_3-1626359661654.png

 

Any insight you can provide is greatly appreciated! Thank you in advance Community!

Cherie

10 REPLIES 10
benjaminmartin16
6 - Meteoroid

Had a similar problem in the most recent version of altyerx when i changed the data source

Labels