I have a workflow that outputs to an Access Dbase and that works just fine. However, if I add another output to also push the results up to our Mainframe I get an error message: "Output Data (38) Error creating table [tbl and Teradata mentioned here] Syntax error: Data Type "text" does not match a Defined Type name. ¶CREATE MULTISET TABLE [tbl and field names mention here]". What is strange is if I take the Alteryx created Access Dbase and create another workflow and push that out to Production - it works fine. Another strange wrinkle is if I add a single tool (any tool) between the dbase and the output in this new, work around, workflow - I get the same error. Anyone run into this? Any ideas on solution? Thanks in advance.
