Forum Discussion

PeteZ's avatar
PeteZ
New Member
6 years ago

Add Table by Example not returning all rows?

Hi - I've been trying out the feature "add table by example" against the following website: https://hl7-definition.caristix.com/v2/HL7v2.8/TriggerEvents.  I've noticed that for this site that Power B...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
PeteZ - Can you share your Advanced Editor code?
PeteZ's avatar
PeteZ
New Member
6 years ago

Hi -- below is the Advanced Editor code:

let
    Source = Web.BrowserContents("https://hl7-definition.caristix.com/v2/HL7v2.8/TriggerEvents"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".mat-h3"}, {"Column2", "P[cdk-describedby-host=""""]"}}, [RowSelector=".mat-2-line"]),
    #"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}, {"Column2", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Trigger"}, {"Column2", "DescriptionLong"}})
in
    #"Renamed Columns"

 

Thanks