Stitch Files Together

[jamesfbeard]

I have a Macro that sticks multuple different files together - to be honest, the macro is overkill as these files all have the same schema. However, the process that creates these files that get stuck together has now started outputting some of the fields as V_String instead of V_WString - the Macro and using a normal input with a wildcard does not like this at all. Is there any way for a workflow to stitch files together even though Column A (which has the same title) has a different metadata type?

[DataNath · Accepted solution]

Hey @jamesfbeard, I've just answered what appears to be a very similar request. Only instead of null values in a field throwing off the schema, your system generating some file columns as V_String rather than VW_String is doing so. Therefore, you could perhaps add in the same workaround with the Select tool being used to force the problem fields into a standardised datatype before going to the macro output: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-Multiple-Sheets-On-One-E...

[jamesfbeard]

This worked perfectly! Thanks @datanath!