I want this in this way
reviewer Id name text helpful
12323 hgdge this is not working 3
i.e each row contains column names i have to make table in such a way where column names must be as column header and no row contain column name in its cell
and some errors are show how to overcome them
Please can someone help me with
Thank You
Yup sure try.txt (49.6 KB)
this is my file
i want to achieve a table with column headers (reviewerID , asin , reviewerName …)
and respective values in each row
This working well but my file has 25 rows and table is showing all 25 rows with Huge garbage data in table how to remove that garbage data
Please help me
I toyed around with the example a little bit and came up with the following solution. Which is:
Import the Text file as one large column width: 500
convert the column into JSON
manually define JSON paths for each column (or see if the default setting does the trick)
remove the “column*” columns
export the resulting data with headers
I now have a few empty lines but maybe that was the case if not they could be removed.
If data is missing it could be feasible to expand the width.
Then if you have garbage in your data it could be because of UTF-8 encoding. I had a similar problem and had to change a setting in the knime.ini (until KNIME would have fixed a problem). If you still experience this problem I could try to look up the solution I got.