Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying use Text.Combine to concatenate the values from two columns which are both text but I get the error
"We cannot convert the value "003011" to type List.
Details:
Value=003011
Type=[Type]"
Anybody any thoughts.
Thanks in advance
Solved! Go to Solution.
Hello @Anonymous
Text.Combine takes a list and you are feeding it with a text-value. This is the problem. How are you referencing your two columns ? you need to have the result on row level? Then just use [Colunn1]&", " & [Column2].
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello @Anonymous
Text.Combine takes a list and you are feeding it with a text-value. This is the problem. How are you referencing your two columns ? you need to have the result on row level? Then just use [Colunn1]&", " & [Column2].
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Thank you very much, that's worked for me.
@Anonymous Please check if there are no null values in your dataset. It is possible that null values might be preventing you from performing the task that you are trying to achieve.
Proud to be a Super User!