File handling based on extension e.g. excel or csv (",", ".", "|", ";", ":", " ")

Question

Hi all,

There must be a way to recognise a file type (e.g. csv or excel) then process it accordingly. Any recommendations how this could be handled?

The idea is that the user is prompted to select which file type is it e.g. csv or excel and then the workflow reads the excel or csv regardless of user specifying the delimeter. This would be useful to view the contents of the files with more than 10 million rows as excel has limitations.

Thank you in advance for your replies.

PhilippK · Answer

With Analytical Applications you can ask the user to read in certain file types only.
More precisely, you need the FILE BROWSE tool:

Here you can learn more about the concept of Analytical Apps:

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%20Analytic%20Apps

I hope this helps you Danial.

danial_j · Answer

Hi @PhilippK , thank you for your response. Is there a workaround other than directory tool? The problem with directory tool is that it is supported in the gallery because of restricted system level access

PhilippK · Answer

Hi @danial_j ,

you can leverage the DIRECTORY tool for that (cf. attached).

Best regards

Phil

Directory.yxzp