The problem is that the string of source data not always contains all the variables. So I’m looking for a solution to structure the data like in the target picture . .
use Unpivoting node two times (parallel). Once to get all types in single column and another time to get all values in single column
then simply append those two tables and pivot
I used regex, wildcard and type selection to make workflow run successfully regardless of webscraping result. Here is workflow example. Take a look and if any questions feel free to ask. KNIME_structuring_data_ipazin.knwf (14.2 KB)
I have another problem that look’s like before but I cannot get the right solution. Maybe someone has an idea
See below an example . . . from webscraping I generate a string. The structure is that the sequence of the year(s) correspond with the values. Hopefully the example is clear.
My goal is a structured table . . . but how ???