What I need to find is how I copy the value “Paquetes de maternidad” on another column and fill the rows until “Zacatecas”, then, take the next value “Procedimientos Ginecol…” and do the same, I really try with diferent nodes but I can’t get the solution, must be something like this
@Jetro your solution might look something like this. Maybe you provide us with the sample data. It will be a combination of using row_ids to identify the ‘markers’ jon them back into the starting place and then sort by the row_id and then fill in the blank lines with the values (with the help of the Missing value node - using the last value if missing).
Hi @badger101 !
I think I’m close to the solution with your help, It’s my first time in the forum and It’s amazing this community.
I left you my data, I try with your solution but I don’t get the final table. First knime work.xlsx (23.0 KB)
Here’s the updated workflow to strip all the unwanted spaces. It’s performed by the String Manipulation Node before the Missing Value Node. In the future, if you need other type of manipulation for cleaning up the raw data, you just add the new relevant nodes before the Missing Value Node like I did here.