After execute code in knime python script node got error like knime user error: output table'0' must be of type knime.api.Table or knime.api., Batch output table but got None. Did you assign the output table.

[mlauber71]

@Rohit_208 welcome to the KNIME forum. Maybe you can check if the data in and out is correct.

Help to use Python do insert variable in SQL code

@Aldemir you can export data from within the Python node as Flow Variables or as a dataframe (from a pandas dataframe). The code would look something like this: import knime.scripting.io as knio import numpy as np import pandas as pd # bring your string to a Flow Variable knio.flow_variables['var_txt_cbi'] = txt_cbi # bring your content to a pandas data frame output_table = pd.DataFrame({'column_txt_cbi': [txt_cbi]}) # bring the dataframe back to KNIME knio.output_tables[0] = knio.Table.f…

Python scripting node data input

@Bob_Nisbet the in and out syntax would look like this for pandas dataframes. import knime.scripting.io as knio import numpy as np import pandas as pd # data from KNIME to Python (pandas) df = knio.input_tables[0].to_pandas() # data from python (pandas) to KNIME knio.output_tables[0] = knio.Table.from_pandas(df) KNIME would work internally with Arrow format https://docs.knime.com/latest/python_installation_guide/index.html#usage-examples

Also maybe you can provide the whole code in a readable form as a separate file or preformated.