Comparing 1 json object against another json objects

Anonymous,

Try this in Power Query:

let
  Source = Table.NestedJoin(Table1, {"Record ID"}, Table2, {"Record ID"}, "Table2", JoinKind.Inner),
  RenameColumns = Table.RenameColumns(
    Source,
    {{"Name", "Table1.Name"}, {"Industry", "Table1.Industry"}, {"City", "Table1.City"}}
  ),
  ExpandTable2 = Table.ExpandTableColumn(
    RenameColumns,
    "Table2",
    {"Name", "Industry", "City"},
    {"Table2.Name", "Table2.Industry", "Table2.City"}
  ),
  AddName = Table.AddColumn(
    ExpandTable2,
    "Name",
    each if [Table1.Name] = [Table2.Name] then "Yes" else "No"
  ),
  AddIndustry = Table.AddColumn(
    AddName,
    "Industry",
    each if [Table1.Industry] = [Table2.Industry] then "Yes" else "No"
  ),
  AddCity = Table.AddColumn(
    AddIndustry,
    "City",
    each if [Table1.City] = [Table2.City] then "Yes" else "No"
  ),
  RemoveColumns = Table.RemoveColumns(
    AddCity,
    {
      "Table1.Name",
      "Table1.Industry",
      "Table1.City",
      "Table2.Name",
      "Table2.Industry",
      "Table2.City"
    }
  )
in
  RemoveColumns