Forum Discussion
Reorder Error Token Comma Expected
Anonymous ,
OMG!
"I'm sure you can easily spot the issue" 🤣
Seriously though.
1) You're trying to reorder your columns twice, in both step #"Reordered Columns" and #"OrderItems". However, your #"OrderItems" step refers to a previous step that doesn't exist:
Fix this first, then see if you still have an issue.
2) In your #"Changed Types" step, you're typing columns as 'any'. I don't think this will fix the issue, just really bad form.
3) The number of columns you're trying to work with is obscene. Try only selecting the initial columns that you need to start out, then add extras in one-by-one as and when you need them. I don't think this will fix the issue, but it will make debugging a nightmare (this post is case in point) if you try and handle the whole table like this from the outset.
Pete
Anonymous ,
OMG!
"I'm sure you can easily spot the issue" 🤣
Seriously though.
1) You're trying to reorder your columns twice, in both step #"Reordered Columns" and #"OrderItems". However, your #"OrderItems" step refers to a previous step that doesn't exist:
Fix this first, then see if you still have an issue.
2) In your #"Changed Types" step, you're typing columns as 'any'. I don't think this will fix the issue, just really bad form.
3) The number of columns you're trying to work with is obscene. Try only selecting the initial columns that you need to start out, then add extras in one-by-one as and when you need them. I don't think this will fix the issue, but it will make debugging a nightmare (this post is case in point) if you try and handle the whole table like this from the outset.
Pete