Power query to reconcile accounts that do not have a common column

#excel #powerbi #powerquery
Learn how to reconcile accounts that do not have a common column using power query. This video is a follow on to the article
theexcelclub.com/how-to-recon...
and video • How to Reconcile Accou...
where you learn to reconcile accounts such as bank accounts using Power Query. However, in that article and video, both sets of records had a common column.
This video shows you what to do when you do not have a common column in tables you are trying to reconcile with Power Query
Watch more Power BI videos
• Power BI
Watch more Excel Videos
• Learn Excel - Playlist

Пікірлер: 17

  • @wayneedmondson1065
    @wayneedmondson10654 жыл бұрын

    Hi Paula.. great trick.. thanks for sharing it. Thumbs up for The Excel Club!!

  • @SimX9000
    @SimX90003 жыл бұрын

    Life saving. Thank you

  • @KD-xp2eo
    @KD-xp2eo2 жыл бұрын

    Thank you so much!!! This helped me out a ton!!!

  • @jaliali84
    @jaliali843 жыл бұрын

    Thanks, Paula this is simple and powerful

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    3 жыл бұрын

    good stuff!!

  • @sleek12
    @sleek123 жыл бұрын

    I really need this, am following it.

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    3 жыл бұрын

    :-)

  • @ezekieladesawe239
    @ezekieladesawe2394 жыл бұрын

    Awesome trick. This video is very helpful and valuable

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    4 жыл бұрын

    Glad you think so!

  • @aasishkumar267
    @aasishkumar2674 жыл бұрын

    Hi Paula...Thank you so much

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    4 жыл бұрын

    You are so welcome

  • @hasinarafenoarisoa7063
    @hasinarafenoarisoa70633 жыл бұрын

    thank you so for this video! watching from Madagascar Could you make videos about auditing with powerquery and powerpivot, please?

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    3 жыл бұрын

    Thanks for the idea!

  • @azmanfc
    @azmanfc3 жыл бұрын

    Thank you very much for the video, but how about the reference between the bank and the GL not standardized. I mean here, probably reference in the GL not actually match like to like in the bank statement, example, in the GL, the reference number probably in the middle of the description, can you show us that situation, for specific probably using consist of the text. Thank you very much

  • @evanyeung3801
    @evanyeung38013 жыл бұрын

    I don’t think this will work...

  • @PaulaWeb3andCrypto

    @PaulaWeb3andCrypto

    3 жыл бұрын

    well? How did you get on?

  • @aslabivad792

    @aslabivad792

    3 жыл бұрын

    @@PaulaWeb3andCrypto I have tried too, bank description has nothing in common apart values, your seem to be the same, bc mine are different I get null for everything when I try to merge queries, not sure what i am doing wrong. Thx