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

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

File Path example.PNG

Output tool configured as .yxdb

Output Data.PNG

Thanks,

Michael

Publish

Datasets

Developer

Output

Best Practices

Preparation

Accepted answers

apathetichell

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.

All comments

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

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703