I will explanning a little more about the problem. I have one column to CNPJ(like a business code here in Brazil), but in some lines there may be more than one cnpj separated by the string + and what I want is for each of these CNPJ to come in new lines with all other columns the same. In the 1st photo I carry the situation of my problem and in the 2nd photo what the ideal solution would be, the others are precisely my difficulties. Thank you!
No exactly my friend, the ungroup transform the list but I need one CNPJ below the other in consecutive lines, as shown in figure 2 in my question. I will show with your suggestion:
You can use the Cell Splitter node and set the plus sign “+” as the delimiter and select “As set” or “As list” in the output section. You can also check the option to remove the source column. Then, by using the Ungroup node and including the generated column in the previous step in the configuration dialog, you will have what you are looking for in the output.