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.

v-kkf-msft's avatar
v-kkf-msft
Community Support
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.

pAAmckelvey's avatar
pAAmckelvey
Frequent Visitor
5 years ago

Thank you Winniz, I'm not sure why I was so hesitant to try the Rows option and it alleviates the need to unpivot as well!

Patrick