Expression Error

[Danish_Bhat]

Expression Error: We cannot convert the value (AeccDbsurfaceTin) to type table. The data is coming in the xml format, there in this particular data is an exoansion of Table which has most of the columns "null" and some as text or text & integer.

[Danish_Bhat]

Hi @pratyashasamal am not able to follow up on any whatever you suggested. My data contains a mix of text and integer values, if I'm removing the error causing value from the source file then it is working but I have to have all the values whether empty or not. If required I can share the snips of transformations and editor code.

[pratyashasamal]

Hi @Danish_Bhat ,
You can use Table.Isempty() function to check if the table is empty. If it is not empty, then you can refer to the column in the table and do some transformations. Or you can refer to Error Handling to troubleshoot the error.
Thanks ,
Pratyasha Samal 
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C