- Type: TableData TableThe data table generated from the supplied table text
Returns a table based on the delimited text contained in a single text field. e.g. If the text is name|age|city Alan|25|London Brian|23|New York Charlie|30|Sydney then with a delimiter of | This would return a table with the columns "name" "age" "city" and the data aligned in their columns. The main driver for writing this component was the presentation of "sample data" on the forum, where it then takes time to translate the posted data into an actual table. Simply paste the data into the supplied multi-line text field, specify: + column delimiter + row delimiter These can be any value that is acceptable to the Cell Splitter node. Tab can be specified with \t New Line can be specified with \n If you want to use \ as a delimiter, it should also work. There should not be a need to escape but if you have problems, try specifying \\ @takbb Brian Bates v1.3 29 October 2022 - update to handle different datatypes appearing in same column - explicitly converts to String v1.4 30 October 2022 - removes any columns that get created with a column name of <empty_.* which is caused when the column delimiter is initial character
Used extensions & nodes
Created with KNIME Analytics Platform version 4.6.3
By using or downloading the component, you agree to our terms and conditions.