Validation error "The field is not contained in the record {Action=Avg}"

[slobo]

Hi guys,

I'm having issue with the validation of the workflow. I performed all checks, no field is missing. 

Does anyone have idea what this error is about?

[dougperez]

Can you show the tool 459?

[slobo]

@dougperez thanks for quick answer!

[dougperez]

Is your input a file ? The server have permissions to "see" it?

[dougperez]

Read the comment of the Hiblet in this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Field-is-not-contained-in-the-record/t...

Try to "force" the field to exist

[slobo]

Input tool goes into summarize tool (screenshot I posted previously). Server and input files are functioning correctly. 

I tried now with Block until done, but same error appears. 

Error appeared when I added Summarize and Join tool, before that, everything was okay. 

[atcodedog05]

Hi @slobo 

Did you try running the workflow in gallery?

[dougperez]

Try to create a text input with your fields and put nulls or 0 into them (just one line) and union with your select, just to ensure that your field exists into the workflow. Do that only in your R input.

[slobo]

@atcodedog05 Yes, and it works fine, without errors 🙂 

@dougperez I tried that now, same error...

[atcodedog05]

Hi @slobo 

If it works then no need to worry. The data stream might not have updated 🙂