Forum Discussion
Helper IIIError (row index 1)
Hi all, for a while now, the PBI has been working well for me until today. I suspect I may have deleted a step, and now I cannot figure out what went wrong. I look up the error but I don't understand. Does this line in red mean give you any clue that can help me? I am afraid it is not possible for me to share the other queries as there are many tables appended together. Appreciate the advice from a kind soul. Thanks.
Sincerely,
Patrick
let
Source = #"Table20191307 (Appended)",
#"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1),
#"Kept Errors" = Table.SelectRowsWithErrors(#"Added Index", {"Job Ty", "Svc Ty", "Job Mo", "Booker", "Cty", "Partner", "Ship Org", "Ship Dest", "Company", "WT", "Unit", "Relo", "Relo Cty", "Transferee Name", "Delvy Date", "Start Date", "End Date", "Shpt ETD", "Shpt ETA", "Coordinator", "POE", "No of Inv.", "Inv.AMT", "Year (TEXT)", "R-Date", "YYYY", "TYPE", "Country", "Year"}),
#"Reordered Columns" = Table.ReorderColumns(#"Kept Errors", {"Row Number", "Job Ty", "Svc Ty", "Job Mo", "Booker", "Cty", "Partner", "Ship Org", "Ship Dest", "Company", "WT", "Unit", "Relo", "Relo Cty", "Transferee Name", "Delvy Date", "Start Date", "End Date", "Shpt ETD", "Shpt ETA", "Coordinator", "POE", "No of Inv.", "Inv.AMT", "Year (TEXT)", "R-Date", "YYYY", "TYPE", "Country", "Year"})
in
#"Reordered Columns"
9 Replies
- amitchandak
Super User
PGAT , Have you created an index column and used it in some other column and deleted it , reverse the deleted step(remove it), or add it again
- parry2k
PGAT update your line as below, it is a missing last parameter:
#"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1, 1),I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
PGATHi there, thanks, what do you mean by missing last parameter?
- PGAT
Hi Amitchandak, thanks, oh no... I am really not sure. All the steps look so right. Oh man...
