Convert .NUMBERS files to another extension

Corent

Hi There,

I need to input numerous  . Numbers files (varying between 20 to 40 files) into Alteryx. The .numbers extensions are not the same (see below snapshot) and therefore the *.csv does not work.

Without using a converter online, would you have any tips on how to convert them or how to load them into Alteryx at once? 

Cheers,

C.

BrianR

Hi @Corent, there's a similar post on Community that is close to what you are looking for - 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Renaming-files-at-system-level/td-p/370717

With the example workflow and information shared by @DavidP, I modified it a bit to mock up an example that I was able to use to rename the files, adding a .csv extension to them. With them renamed, you can then read them all in with Designer.

A few notes - one, I made the assumption that although these files were named with extensions consisting of numbers, that they were in fact, csv files. Secondly, I made the assumption that it is actually ok to rename the files. I know you said you didn't want to use an external program, but hopefully it's ok within the scope of the Alteryx Run command?

In any case, take a look at this modified version of David's workflow (thanks @DavidP !)

Brian

NumberedFiles.zip