Filter Massive CSV using PowerQuery in Excel

Поділитися
Вставка
  • Опубліковано 28 жов 2024

КОМЕНТАРІ • 14

  • @krypt777
    @krypt777 9 місяців тому

    2 year old video and still gave me the best method, Thanks alot

  • @nicholashall3479
    @nicholashall3479 6 місяців тому

    This was enormously helpful to me. Thanks so much!

  • @sharifskijr.1257
    @sharifskijr.1257 Рік тому

    You're simply awesome!

  • @r0260064
    @r0260064 2 роки тому

    Thanks for the help! Important note: Do not changetype for any of the columns before doing the merge action, this gives errors.

  • @SA-kt3wt
    @SA-kt3wt Рік тому +1

    Thanks - this is slower but simpler for those of us who dont have SQL experience (the go to for this stuff!).
    Can you match two columns? E.g. let's say county and sales date April in your example?

  • @srinivaspavali3550
    @srinivaspavali3550 2 місяці тому

    Thank you so much

  • @Jizzus-l7w
    @Jizzus-l7w Рік тому

    Hello, I have two similar lists, but in my case i want to remove the countries that are in europe from the 1.6m rows CSV. any ideas on how to do it?

  • @wilfredo2752
    @wilfredo2752 3 роки тому

    Great! Thanks for your video.

  • @nknaru007
    @nknaru007 5 місяців тому

    can we import multiple csv files?

  • @Amit_Singh777
    @Amit_Singh777 3 роки тому

    Hi , I have two files(say excel) from two two different sources..I want to compare these two files for any difference (if any)... After comparison I want to do the same comparison(basically automate) for other years in power query . Can you help me in this.

  • @AidonakS
    @AidonakS 5 місяців тому

    Thanks 😄

  • @supriyapawar8417
    @supriyapawar8417 2 роки тому

    Hi, can you please show how we can convert csv file with millions of data into excel . Like i want to export all those millions data into excel. Thank you

  • @manishjargamagar5925
    @manishjargamagar5925 3 роки тому

    its tooo fast, could not understand anything.