Forum Discussion

pAAmckelvey's avatar
pAAmckelvey
Frequent Visitor
5 years ago
Solved

Split Column function not creating the correct number of columns on refresh

Trying to create a robust reference table to assist in filtering data in the table it is based on.  For the most part it works which is great but the problem arises during the refresh process which i...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    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,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rasanen's avatar
rasanen
New Member
3 years ago

Hello, I am facing a similar kind of a problem when trying to divide the name of a certain product by delimiters ("/" in this case). 

 

I used this as quoted above 

#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Tags", Splitter.SplitTextByDelimiter(";", QuoteStyle.Csv), {"Tags.1", "Tags.2", "Tags.3"}),

with one extra column, but for some reason the third column includes errors in each of the products when the third column includes more than just numbers (so "12" is okay, but "A12" is not). This does not happen in other columns.

 

I can change the type of the data included in the column but still won't work when I close and apply the changes made in the data. Any ideas?