Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Publishing Outlook Input Tool to server

Highlighted
6 - Meteoroid

Having trouble publishing to the server using a join tool in combination with Outlook Input tool. (Just for kicks I tried several of the other tools in the Join category and had the same problem.)  Publishes fine if I take out the join. 

 

Workflow:

clipboard_image_1.png

Error:

clipboard_image_0.png

Highlighted
ACE Emeritus
ACE Emeritus

Try adding a Block Until Done tool after your DateTime parse. It may be that your Join is trying to run before enough data from the Outlook tool has been retrieved.

@thizviz aka cbridges, Bolide
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
Highlighted
6 - Meteoroid

Thanks for the suggestion. Still get the same error using any of the Join tools.

Highlighted
ACE Emeritus
ACE Emeritus

Hmm

 

Are the field types you're joining on the same?

 

Every once in a while, when I come across weird join errors, I'll add a browse immediately after my 2 inputs (or in your case after the dateparse). Then select the first record, copy with headers, and paste onto the canvas. This gives you a text input tool with your data headers and one row of data. Delete the data row, and union this with your original. Then connect that to your join. 

 

I think, at least in my case, there are instances when a source actually has no records. This method prevents the join from failing outright.

 

ThizViz_0-1572466618170.png

@thizviz aka cbridges, Bolide
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
Labels