Identify Keyword in a table and populate results in rows and columns against the rows in the sample table

Dear all

I am trying to identify the presence of key words (~7000) in a particular column with 1300 rows and would like to populate a table with 7000 columns whose header is the keyword itself, and then populate this table with 1 or 0 for keyword present and absent, attached is the example for the same


Hi jagmohan,

Here is my solution, hope it helps.
As the first step, you need to extract “sharedStrings.xml” file from your XLSX file.
Just make a copy of the XLSX file and on that copy change file extension to ZIP.
Then unpack “sharedStrings.xml” file from it and point path to this file in “XML Reader” node. (55.5 KB)

1 Like