Hard one to know without actually testing it and seeing if I think.
But the great thing about the query editor is you can just play around and you won’t break anything. Have you tried a few things to see if they fix it?
Did you jump back into a previous transformation and attempt to change it?
This is a pure guess but you see below
The type is different, so it may not be finding the correct column? I’m not sure but this is my guess at where the error could be coming from
Let me know.
If it’s just isn’t working and you can’t work it out, I would just delete each transformation from the end backwards. Then just build it up again.
I do this often. It’s one of the great things about the query editor.