Hi everybody I am trying to loop over several columns in order to spot specific string values (which are Excel errors in values #REF!, #DIV/0!,#VALUE!, #NAME?, etc.), at the end I want to append the columns that meet such criteria.
Thank you
Hi everybody I am trying to loop over several columns in order to spot specific string values (which are Excel errors in values #REF!, #DIV/0!,#VALUE!, #NAME?, etc.), at the end I want to append the columns that meet such criteria.
Thank you
Hi,
and what is the question? :-)
Is it not working?
Cheers, Iris
You might also want to check this example: https://www.knime.org/nodeguide/control-structures/loops/looping-over-all-columns-and-manipulation-of-each
There the usage of the column looping is explained.
Cheers, Iris
Hi Iris yeah it is not working and I will have a look on the link that you provided
Cheers
Hi Iris I managed to solve the problem, but I have the following escenarios:
SAME AMOUNT OF RECORDS WITH ERRORS IN THE COLUMNS | ALL COLUMNS HAVE ERRORS | OUTPUT | ERROR MESSAGE | |
SCENARIO 1 | NO | NO | DOES NOT WORK | Tables can't be joined, non matching row counts: 7 vs. 0 |
SCENARIO 2 | NO | YES | DOES NOT WORK | Tables can't be joined, non matching row counts: 4 vs. 1 |
SCENARIO 3 | YES | YES | WORK OK | N/A |
In the first scenario not all the columns have errors (or strings that I want to spot with the node Reference Row Filter) and the amount of records differs in the correspondent columns, for that reason the error message says 7 vs 0.
In the second scenario all the columns have errors but the amount of records differs in the columns, for that reason the error message says 4 vs 1.
In last scenario everything works as is the least realistic one (just being sarcastic).
I wonder if there is a way to append several columns with different dimentions like the Concatenate optional in node with the option union of columns?
Best Regards