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? 

[Emil_Kos]

Hi,

I believe the easiest way would be using two inputs tool and the wildcard to import mutliple files.

Please watch this movie to understand it better:

https://www.youtube.com/watch?v=1y1gFXDkYwA

If this was helpful please mark as a solution. 

[vijaylnyadav]

Here i have a different number of columns and different number of data types.

Please suggest me alternative solutions so that I can do my assignment

[Qiu]

@Emil_Kos 

😓

[Emil_Kos]

Hi @vijaylnyadav 

Please check this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Import-multiple-excel-file-different-s...

I believe it should be helpful 

@Qiu 😀

[vijaylnyadav]

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

[vijaylnyadav]

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.