Forum Discussion
data querry error reorder
- 1 year ago
Thanks all,
I check the column error message and found the problem. There was an error in smartsheet which I was able to fix and now it's working!
ToddChitt , danextian , fahadqadir3 ,
not 100% sure where to fine the error message.
Is the what you mean?:
= Table.ReorderColumns(#"Kept Errors", {"Row Number", "RowNumber", "Sheet Name", "Primary", "Article CC Developer", "Article Development Type", "Article Factory Appropriate SEC Claim", "Article Factory Confidence Level (biz) >75%", "Article Factory Confidence Level (BOM errors)", "article Number", "Article Product Manager", "Article Retail Intro Date", "Article Senior Developer", "Article Status", "Biomech. Test + MST", "briefed after", "CAD available in CP", "Category Marketing Line", "Colorway Name", "CR1 AC-T Delivery date HZO", "CR1 AC-T sample delay reason", "CR1 AC-T sample needed?", "CR1 AC-T sample sent on time?", "CR1 Actual ex-factory date", "CR1 Actual ex-factory date AC-T samples", "CR1 Actual ex-factory date early wear test", "CR1 AWB# AC-T sample", "CR1 AWB# DEV sample CCH", "CR1 CAD confirmed on", "CR1 CAD Confirmed On Time?", "CR1 delivery date HZO", "CR1 Dev Handover date", "CR1 Dev Handover on time", "CR1 Dev Sample delay reason", "CR1 Dev sample needed?", "CR1 early warning AC-T samples", "CR1 Early wear test delay reason", "CR1 Early Wear Test needed", "CR1 Early Wear Test send on time", "CR1 FF stack heights mm", "CR1 Material confirmed on", "CR1 Materials confirmed on time?", "CR1 Material confirmation deadline", "CR1 Dev Handover Deadline", "CR1 Cad Confirmation Deadline", "CR1 Models Weight g", "CR1 Pattern Confirmation deadline", "CR1 Pattern confirmed on", "CR1 Pattern confirmed on time?", "CR1 Planned ex-factory date", "CR1 Planned ex-factory date AC-T samples", "CR1 Planned ex-factory date early wear test", "CR1 RF stack heights mm", "CR1 Sample sent on time?", "CR1 Tech Pack confirmed on time?", "CR1 Tooling confirmation deadline", "CR1 Tooling confirmed on", "CR1 Tooling confirmed on time?", "CR1 Warning early wear test sample delay", "CR1 Warning sample delay", "Fit Test + MST", "Halo Calendar", "helper column", "Helper SEC", "Intended Use", "LO Developer", "Marketing Department", "Model count", "Model Number", "Model Status", "Overall Article Test Status ""Ready for BUY READY""", "Overall FGT Result", "Performance Test + MST", "Sales Line", "Sustainability and Ethics Compliance (All)", "Sports Category", "Target Weight", "Test Analyst", "Test Level", "Wear Test + MST", "Weight critical model", "Article 9oo10", "Days Countdown BUY READY", "CR2 AC-T Delivery date HZO", "CR2 AC-T sample delay reason", "CR2 AC-T sample needed?", "CR2 AC-T sample sent on time ?", "CR2 Actual ex-factory date", "CR2 Actual ex-factory date AC-T samples", "CR2 CAD Confirmed On Time?", "CR2 Color & Material Team detailed comments", "CR2 Delivery date HZO", "CR2 Dev Handover on time", "CR2 Dev sample needed?", "CR2 Dev Sample delay reason", "CR2 FF stack heights mm", "CR2 Materials confirmed on time?", "CR2 Models Weight g", "CR2 Pattern confirmed on time?", "CR2 Planned ex-factory date", "CR2 Planned ex-factory date AC-T samples", "CR2 RF stack heights mm", "CR2 Sample sent on time?", "CR2 Sample status against CAD & Material Map", "CR2 Tech Pack confirmed on time?", "CR2 Tooling confirmed on time?", "Final Weight Range in g", "MCS sent to NUREG", "article creation date MP", "MCS", "CR2 CAD confirmed on", "CR0 Models Weight g", "Final Weight Range in g.", "CR0 AC-T Delivery date HZO", "CR0 AC-T sample needed?", "CR0 AC-T sample sent on time?", "CR0 Actual ex-factory date", "CR0 Actual ex-factory date AC-T samples", "CR0 CAD confirmed on time?", "CR0 delivery date HZO", "CR0 Dev Handover on time", "CR0 Dev sample needed?", "CR0 Dev Sample sent on time?", "CR0 FF stack heights mm", "CR0 Materials confirmed on time?", "CR0 Pattern confirmed on time?", "CR0 Planned ex-factory date", "CR0 Planned ex-factory date AC-T samples", "CR0 RF stack heights mm", "CR0 SEC Check", "CR0 Tech Pack confirmed on time?", "CR0 Tooling confirmed on time?", "Lead Colorway", "Lead Time", "T1 Factory Short Code"})
- danextian1 year agoSuper User
One or more columns in that query will show an error for all or several rows. Click on one of the cells to show the error.