Unable to combine data...AutoRemovedColumns1...Please rebuild this data combination

[Anonymous]

Hi, can anyone help to mask these two queries together with function?

let

Source = Web.BrowserContents("https://companysales.com:businessReportTemplate?username"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE > * > TR > :nth-child(1)"}, {"Column2", "TABLE > * > TR > :nth-child(2)"}, {"Column3", "TABLE > * > TR > :nth-child(3)"}, {"Column4", "TABLE > * > TR > :nth-child(4)"}}, [RowSelector="TABLE > * > TR"]),
#"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"", type text}, {"File Name", type text}, {"Size (bytes)", Int64.Type}, {"Date Modified", type text}}),
#"Extracted Text Before Delimiter" = Table.TransformColumns(#"Changed Type", {{"Date Modified", each Text.BeforeDelimiter(_, ","), type text}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Extracted Text Before Delimiter",{{"Date Modified", type datetime}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type1", let latest = List.Max(#"Changed Type1"[Date Modified]) in each [Date Modified] = latest)
in
#"Filtered Rows"

let
Source = Excel.Workbook(Web.Contents("https://companysales.com:", [RelativePath="businessReportTemplate?username=JohnDoe&doc="&Latest[File Name]{0}]), null, true)
in
Source

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly share your solutions. More people who encounter the same issue will benefit from here. If you are still confused about it, please share more details to us. 

[v-xuding-msft]

Hi @Anonymous ,

You could take a look at Shape and combine multiple data sources firstly.

We can't access your data. So we don't know what happen to you based on the code. If the document can't help, please share a few screenshots and some details. We will understand more clearly.