Forum Discussion
Index Error
Anonymous - OK, this seems to be the same problem as here:
Change this:
= Table.AddIndexColumn(#"Added Index", "Index.1", 0, 1, Int64.Type)to this:
= Table.AddIndexColumn(#"Changed Type", "Index", 0, 1)Maybe get rid of the Int64.Type? Wait, maybe it doesn't like that you sorted the rows and didn't do a Table.Buffer? v-deddai1-msft
hi everybody, Please i need help with the next topic.
I have a querry and I want to be able to transform a column with nested tables, I need to delete the columns that I do not need, but as some tables have more column than others, it sends me a message that does not find column 18 or some other that does not have another table, the querry is this, suddenly some suggestion. if I place it the missginfield.ignore sends me that other message
Table.TransformColumns(Headers, { "Data", each
Table.RemoveColumns(_, Lista_Final),MissingField.Ignore })
Expression.Error: No se puede convertir el valor 1 al tipo Type.
Detalles:
Value=1
Type=[Type]