File path saved as .csv but output type set as .yxdb - can I recover files?

[MDonnel8]

Hi all,

I made an error when trying to make a daily archive of data from my workflow. I created a string called File Path which was the location I wanted to store my archive, plus the name of the file with today's date - the extension I used on the file was .csv. However, when setting up the output tool, the file type was accidentally set to .yxdb which caused the file to output unreadable data when opened either in excel or through Alteryx. I've fixed the error going forward but is there a way I can recover the already archived files so I don't lose all my historical data? Ideally I would like the recovered files to be in csv format but yxdb would also work.

Any help appreciated!

File Path set as .csv

Output tool configured as .yxdb

 

 

Thanks,

Michael

[abacon]

@MDonnel8 Are you able to right click and open with notepad or whatever text editor you use?

[MDonnel8]

I can but it comes out as the same format as when opened in excel

[apathetichell · Accepted solution]

to convert from .yxdb to .csv - you'll need to build ANOTHER alteryx workflow - yes there are some other ways - but this is the most straight forward one - open the .yxdb  in alteryx. output in csv using an output tool - this time configured to output as .csv.

[MDonnel8]

This seems to work - if I bring in the "csv" files and manually change the file format in the input to yxdb then output again as csv it fixes the issue. Thanks!