Data validation

[vijaylnyadav]

Hi All,

Consider the following sample data,

Full Path Directory File Name
C:\xxxxxxxx xxxxx Maths Syllabus.dat
C:\xxxxxxxx xxxxx English Syllabus.xlsx

I want to read i.e access several text and excel files from a directory tool means all the files under file name i.e Maths Syllabus, English Syllabus, etc

How can i do that?

I am facing a issue with my worflow and that is if I am using excel file as a input it is showing error and that error is: Error: union_csv (2): Record #9: Tool #1: Error reading "xxxxxxx": Too many fields in record #2.

Here, I want to take input as a text file and as a excel file also.

Please suggest a solutions.

[MichalM]

@vijaylnyadav 

@JoeS has built an "Extra Dynamic Dynamic Input" macro that will help dynamically read in files of different types. You can find it here

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Batch-Macro-AKA-the-Extra-Dynami...