Forum Discussion
Split Column function not creating the correct number of columns on refresh
Hi pAAmckelvey ,
You can try to split the column into rows, so that the number of rows will change with the number of tags, and there is no variable limit.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I see you figured it out, but I would like to show my solution to getting the correct number of columns. This doesn't solve the issue when the data is updated and there should have been more columns than before, but at least it produces the correct amount at that spesific time.
I figured out that if my table is to big, the "Split Column by Delimiter" doesn't check all values for the one with most delimiters. To get around this, I created a new column with the number of "delimiters" and sorted Z->A on this column. Then I went to "Split Column by Delimiter", and it found the highest number of necessary columns to produce.
Sorry about the language being in Norwegian, but I hope it's understandable. My delimiter here is \ .
= List.Count(Text.PositionOf([Column1],"\",Occurence.All ))
Thank you Kristian for your response, a clever approach! This could help me in other ways so it is always good to hear others solutions. No worries on the Norwegian, hope to visit Norway in the future.