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
serpiva64 and BA_Pete Thank you very much. I am not sure, how I missed and I am not sure how you could spot it so easily. I am very thankful to you both. I was alerted by my colleague that this may be confidential but I have the solution 🙂 so I will delete if you ok the content. except retaining the error part
No problem at all. I'm new in the community and i don't know very well the uses. I think i have to ask to click the kudo. I'm glad you solved your problem
