I have already set column types to table
enter image description here
Then I added a new column which is a table
enter image description here
so far power query still remember column types of previous data
but when I expand the table, the previous data types were all changed.
enter image description here
i watched a lot videos that explain how to fix that but for the nested table, but i dont need that, i need that a previous data dont change their type when expand nested table
help pls
A code that don’t change a types
Roger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.