i am using the Table Row To Variable Loop Node to read all sheets from an Excel file.
Every sheet contains data of a different KPI (Consumption, Throughput Time, …) but the data tables contain the same information about each KPI (mean, average, delta, …) and also have the same row IDs.
The Loop End Node generates unique row IDs by appending a suffix but I’d rather append the sheet name to the respective row IDs to make them unique.
Is there a way to solve this in KNIME or do I
have to change the row IDs in the Excel sheets?
Thanks in advance!