Icon

yxdb to table

<p>This workflow converts Alteryx yxdb files into KNIME table files.</p><p>The workflow can be easily adjusted to write to any other file format, too, by replacing the Table Writer with any other writer note.</p><p>Note: The Python Script that reads the Alteryx file currently does not handle any more "unusual" data types. Binary objects are turned into Hex strings and can be converted to proper Binary objects afterwards in KNIME. </p>

This workflow converts Alteryx yxdb files into KNIME table files.

The workflow can be easily adjusted to write to any other file format, too, by replacing the Table Writer with any other writer note.

Note: The Python Script that reads the Alteryx file currently does not handle any more "unusual" data types. Binary objects are turned into Hex strings and can be converted to proper Binary objects afterwards in KNIME.

List all yxdbfiles in selected folder
List Files/Folders
Creates a new Python environmentcontaining python 3.11, knime-specific packages andyxdb-py
Conda Environment Propagation
Iterate overpaths
Table Row to Variable Loop Start
String to Path
Read yxdb file
Write toKNIME-native tableformat
Table Writer
Create new paths using.table file extension
Expression
Merge Variables
Variable Loop End
Converts KNIME-relativepaths into absolute paths
Get absolute paths

Nodes

Extensions

Links