Forum Discussion

garich's avatar
garich
Frequent Visitor
2 years ago
Solved

Display only the first record after merging 2 tables

Hi,   I would like to merge 2 tables below linking Customer ID and Person ID where I only need to display the first top record of Table B.   Table: A ID CustomerID 1 123 2 456 3 ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • slorin's avatar
    slorin
    2 years ago

    Hi,

    Step1 = Table.NestedJoin(
       #"Expanded PRS DateExtensions", {"Customer ID"},
       #"PRS HistoricPersonRecords", {"PersonID"},
       "PRS HistoricPersonRecords", JoinKind.LeftOuter),
    Step2 = Table.AddColumn(Step1, "PRSName", each [#"PRS HistoricPersonRecords"]{0}[PRSName])

     Stéphane

garich's avatar
garich
Frequent Visitor
2 years ago

slorin thank you! But how do I handle null values? It is throwing an error

 

slorin's avatar
slorin
Super User
2 years ago

Hi,

 

try [#"PRS HistoricPersonRecords"]{0}[PRSName] otherwise null
if Table.IsEmpty([#"PRS HistoricPersonRecords"]) then null else [#"PRS HistoricPersonRecords"]{0}[PRSName]

Stéphane