Replace column names of nested tables using Power Query | Excel Off The Grid

Поделиться
HTML-код
  • Опубликовано: 23 дек 2024

Комментарии • 9

  • @IvanCortinas_ES
    @IvanCortinas_ES Год назад +3

    Again another great tutorial. The important thing is not to measure how much the person who tells it knows (who has a lot of knowledge), but to know how to tell it in a way that the public finds out. And that totally happens. Then goal accomplished. Congratulations Mark.

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  Год назад

      Thank You Ivan - that’s very kind of you to say.
      I try to share my knowledge in a way that is accessible to others, so hearing that feedback has really made my day 😁

  • @kebincui
    @kebincui Год назад +4

    Excellent as always👍. Thanks Mark. You can save one step of promoting headers if in the first step if you set the second parameter to of Excel.Workbook to true, Excel.Workbook(File.Contents(FilePath), true, true).

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  Год назад

      Good point. It one of those things I know, but rarely remember :-)

  • @Bhavik_Khatri
    @Bhavik_Khatri Год назад

    Excellent video.

  • @MonikaFlight
    @MonikaFlight 9 месяцев назад

    Hi great video, but in my power query I have an error that pq can't find the "Find" column and MissingField.Ignore is not working in this case. is there a way to bypass this?

  • @thebhaskarjoshi
    @thebhaskarjoshi Год назад +1

    Can we expect 30 most useful Excel Office Scripts to automating Excel tasks? Like the VBA pdf one.

    • @ExcelOffTheGrid
      @ExcelOffTheGrid  Год назад

      I’ve not got any plans for that at the moment. Due to the environmental differences between VBA and Office Scripts it’s harder to create universal code examples.
      The Office Scripts course includes a Power Automate code library, and 20+ pages of cheat sheets. So there is information out there, but the focus is different.