Dear KNIME experts,
I am quite new in KNIME but I hope it will fulfill my needs.
I have multiple text files which I already read into a workspace in KNIME and joined them together. So far so good. Now I would like to create an Excel output which depends on the contents of the cells of the tables. I think there are several steps to be done:
I want to select fields for the output depending on the content in other columns. Each row represents a medical case with 100 columns of procedures and 50 coumns of diagnoses. In 100 additional columns there is the date of the respective column of the procedure so that I get 250 columns for each case plus some extra columns. In one ofe these extra columns there is stated an operation date. Now I need only those procedure codes where the procedure dates match the operation date. Those prodedures should be written to an output excel file with one case per sheet.$
I assume that I need a loop of some kind as I don't want to create 100 times the same combination of date and procedure. But I don't get the loop to work. I don't find anything like "indirect" (known from Excel) or "evaluate" (known from visual basic).
Unfortunately there is time pressure on this task as I should finish the results by beginning of next week. Is there anybody out there with experience in this kind of task?