Forum Discussion
Manually add rows in table
hello !
i have 2 tables (Master and Sub-Master (created by using reference from Master)).
i want to manually add rows in sub-master table using advanced editor but there's an error where :
but as you can see above, there's red line under "Weight" and i hover over the error says invalid identifier, but its weird because "Weight" is available in Master table
4 Replies
Any chance there is some invisible sign in the header?
Otherwise, for me being lazy, I would prefer more "drag and drop" approach to insert data - creating a new table in Power Query and and simple append. It gives me easier control when more rows are about to be added (especially with multiple columns). This approach will also give you a hint, if there is anything wrong with your header.i got see this method , i must say this is way more simple than what i did , but i just want to challenge myself to do the hard way but anyway thank you for the suggestion , i'll check again is there any typo error in my header name
butterscotch
Please share the screenshot of the Source step to ensure the column name is correctly refered. Have you got spaces there?As i said before this table is created by reference from Master table, so i cannot manually add the rows in Excel File because the table isnt visible in the Excel File
