Error-row after merge

[Pbendix]

Hello all,

I have read multiple thread for my issue, but non of them could help! 

I have 2 different tables (from service now and Excel) with several columns in each. Each table has a serial number(unique) column, and every serial number consist of number and characters. When i merge (left outer) the two tables on the serial number column I get a merged table with a last row consisting of errors:

If I click on the error I get the message:   

Expression.Error: [Expression.Error] We cannot convert a value "" to type Record. 
Details:
Value=
Type=[Type]

Can someone tell me what causes the error!

Thanks..

[Anonymous]

Hi @Pbendix ,

You may check all queries and all query steps to see if there's an error before merged.

Could you please tell me what's in your last original row? 

After merged, is there a additional column with tables? 

Merging queries doesn't put records but tables in the new column. When this is expanded, then a code step is generated using function Table.ExpandTableColumn.

Your additional column should be a table column (which is a list indeed, but not a separate list).

 The reply from @MarcelBeug  in this post explained well.

Best Regards,

Stephen Tao

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