Not a known file format error workaround.

I've used this article as inspiration to create a batch macro to process batches of files. The files I'm processing are simple text / csv files, however, they have a .chart extension instead of the more standard .txt or .csv. As a result, when I run my macro, I'm getting the following error: Action tool #17 has an error. The file "c:\bel02062012.chart" is not a known format (2).

The script stil runs fine, but with an error. Is there a way I can add the .chart format to Alteryx so that it is a known format.

Input

Output

Accepted answers

s_pichaipillai

I dont think adding a file format to Alteryx is possible

Does .Chart file has the same structure as your txt files withe same delimiters, if so there may be a utility to convert .CHART to Txt Which you can call using Run Command Tool then execute your Main workflow

i think this is the way you can rectify your file format issue

if you can post a sample file of chart extension we can try something

All comments

s_pichaipillai

I dont think adding a file format to Alteryx is possible

i think this is the way you can rectify your file format issue

if you can post a sample file of chart extension we can try something

mutuelinvestor

Thanks for the reply and good idea. If memory serves the Dos command REN should be able to change the extensions for me with a single command: ren *.chart *.txt.

Thanks again,

Jim

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280