Dynamic input tool with diff schema (dbf files)

smallpotato

Hi, due to some path issues, I must use the dynamic input tool for my system. I need to read three nearly identical DBF files. However, I encountered an error stating that the input files have different schemas. Upon checking, I found that Alteryx read one of the DBF files as Wstring, while the others were read as String. In FoxPro, the three DBF files have an identical data schema, where all fields are of type 'characters'. I have already checked the box to output all fields as strings. Could you please advise me on how to fix this issue? Sorry that I may not provide my source data online.

terry10

Since you only have 3 files to input, I would suggest just using 3 separate Input Data Tools. Once the data is in Alteryx, you can adjust the data types and then union the data or whatever.

If you had many files to bring in and there was one that was erroring out due to a field type issue, you could bring in your files as an undelimited text file (set the delimiter to \0 and make sure the Field length is big enough). Once the data is in Alteryx, you can use the Text to Columns tool to parse the data into columns as needed.