About EasyMorph Tutorials & Examples Web-help

Export to tableau multiple files

I want to convert multipme csv files (different columns) to hyper files each.
So i made 2 projects, main and functional(csv_to_hyper)one which is iterated in main project.
Bue when i run all actions, some errors occur.
I think thats because of different columns among files.
For example, a1 a2 a3 a4 a5 columns are in A.csv and b1 b2 b3 b4 b5 columns are in B.csv
if i run all actions, here comes an error message saying “there are no [a1] column in B.csv”
i think there must be some options to autuchange columns for converting to hyper files.
[Export to Tableau]-[Indicate column types]-[Autodetect] : not working (i think this function works for data type)
Is there any way to solve this?

Thanks

Hello @sywon and welcome to the Community!

Unfortunately, column names in the “Export to Tableau” action have to be explicitly specified.

As a workaround, you can try to convert your CSV files to DSET files and then convert DSET files to Hyper files with direct calls to the Tableau Hyper Add-On executable. Here is an example project that converts DEST file to Hyper file:

But you’ll have to specify column type for each column. So this approach may work only if all your columns have the same data type or you can calculate data type from column’s name.

1 Like
To learn more about EasyMorph visit easymorph.com.