Toggle Side Panel

A confirmation code will be emailed when setting up your account or resetting your password—check spam if needed.no-reply@dynamicscommunities.com

Missing records in merge

  • Power Platform

    Missing records in merge

    Posted by DSC Communities on April 11, 2018 at 2:04 pm

    • Carl Loew

      Member

      April 11, 2018 at 2:04 PM

      I merged two queries for combined data rows.  When I utilize the Inner Join the query drops records that should retrieved.  I know this because when I utilize the Full Outer Join all rows show from the right table with information missing in the columns from the left table.  What are some things that I could look for to remedy this situation.  Thanks for your help.

      ——————————
      Carl
      ——————————

    • Carl Loew

      Member

      April 11, 2018 at 2:40 PM

      Found it.  Sorry to bother.  It was the data.  Can’t trust the data.  Remember to clean the data.

      ——————————
      Carl
      ——————————
      ——————————————-

    • Hasham Niaz

      Member

      April 11, 2018 at 8:36 PM

      Hi Carl !

      Glad you figured it out, there is an old saying [data is insane]

      ——————————
      Hasham Bin Niaz
      Sr. BI Consultant
      Karachi, Pakistan
      ——————————
      ——————————————-

    DSC Communities replied 7 years, 11 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Missing records in merge’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!