Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Expression.Error when combining multiple files with the same format

Hi everyone,    I've tried several times to fix the Expression. Error and it was not successful. Maybe you can give me some advices how to solve it. I have around more than 20 files (monthly report...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Jimmy801 

    I solved the problem by myself. I just changed the name of the tab in each file so that they have the same name for the tab. But thanks anyways! 

  • Jimmy801's avatar
    Jimmy801
    5 years ago

    Hello Anonymous 

     

    try to check out this link 

    Please check out also if for this files, where an error is created, if the sheet name is really the same

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy

Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

Hello Anonymous 

 

probably they don't have the same structure. I would need the exact Expression.Error and your custom function to understand what is causing this, because it's your custom function that returns the error.

 

BR

 

Jimmy

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Jimmy801 

    Here is the custom function = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (2)", each #"Transform File (2)"([Content]))

    And the error, please see the screenshot. 

    Thanks!

    • Jimmy801's avatar
      Jimmy801
      Community Champion
      5 years ago

      Hello Anonymous 

       

      try to check out this link 

      Please check out also if for this files, where an error is created, if the sheet name is really the same

       

      If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
      Kudoes are nice too

      Have fun

      Jimmy

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Jimmy801 

      I solved the problem by myself. I just changed the name of the tab in each file so that they have the same name for the tab. But thanks anyways!