Forum Discussion

PGAT's avatar
PGAT
Helper III
6 years ago

Error (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 unders...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

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's avatar
parry2k
Super User
6 years ago

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!

  • PGAT's avatar
    PGAT
    Helper III
    6 years ago

    Hi there, thanks, what do you mean by missing last parameter?  

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      #"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1, 1)

       

      You are missing last parameter ,1 in above M code.

      • PGAT's avatar
        PGAT
        Helper III
        6 years ago

        Hi, thanks again,  the  previous display was from the error page, and it relates to this table below. Where can i go to update the line "Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1, 1)? sorry, do I go to error page to update? 

         

         

        let
        Source = #"Table20191307 (OA)",
        #"Appended Query" = Table.Combine({Source, #"Table20191307 (DA)", #"Table20191307 (CA)", #"Table20191307 (AGT-KCDCA)"}),
        #"Added Conditional Column" = Table.AddColumn(#"Appended Query", "Country", each if [TYPE] = "OS" then [Ship Org] else if [TYPE] = "DS" then [Ship Dest] else [Ship Dest]),
        #"Inserted Merged Column" = Table.AddColumn(#"Added Conditional Column", "Merged", each Text.Combine({[Year], "-1-1"}), type text),
        #"Changed Type" = Table.TransformColumnTypes(#"Inserted Merged Column",{{"Merged", type date}}),
        #"Extracted Year" = Table.TransformColumns(#"Changed Type",{{"Merged", Date.Year, Int64.Type}}),
        #"Renamed Columns" = Table.RenameColumns(#"Extracted Year",{{"Year", "Year (TEXT)"}, {"Merged", "Year"}}),
        #"Replaced Value" = Table.ReplaceValue(#"Renamed Columns","DO NOT USE -THE MI","MOVERS INTERNATION",Replacer.ReplaceValue,{"Booker", "Partner"}),
        #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","DO NOT USE - THE M","MOVERS INTERNATION",Replacer.ReplaceValue,{"Booker", "Partner"}),
        #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","DO NOT USE-THE MI","MOVERS INTERNATION",Replacer.ReplaceText,{"Booker", "Partner"})
        in
        #"Replaced Value2"