Data Validation

Question

Hi All,

Consider the following sample data,

Full PathDirectory File NameC:\xxxxxxxxxxxxxMaths Syllabus.datC:\xxxxxxxxxxxxxEnglish 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?

vijaylnyadav · Answer

I am facing a issue with this 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.

vijaylnyadav · Answer

Thanks a lot for your help.

Now i need one more favour and that is "I want to save different validated excel files into a file location in a excel format" where i will ask the user to specify the output folder and after that the different excel files are saved according to the file name

Emil_Kos · Answer

Hi @vijaylnyadav

Please check this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Import-multiple-excel-file-different-schema-and-union/m-p/533504/highlight/true#M113745

I believe it should be helpful

@Qiu 😀