Is this possible something like this?
Q_Range:
Where is Query1 OR Query2:
Thanks in advance
Q_Range:
Code:
(Query1 as list, Query2 as list ) =>
let
Source = Table.FromColumns({Lines.FromBinary(Web.Contents("[B]https://URL_ADDRESS[/B]"))}),
#"Kept Range of Rows" = Table.Range(Source,[B]List.First(Query1)[/B],[B]List.First(Query2)[/B])
in
#"Kept Range of Rows"
Where is Query1 OR Query2:
Code:
let
Source = Table.FromColumns({Lines.FromBinary(Web.Contents("[B]https://URL_ADDRESS[/B]"))}),
#"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1)
#"Filtered Rows" = Table.SelectRows(#"Added Index", each Text.Contains([Column1], "[B]TEXTSAMPLE[/B]")),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Column1"}),
Index = #"Removed Columns"[Index]
in
Index
Thanks in advance
Last edited: