Log In
Register
Home
January 12, 2021
Offline
Hello together,
I´m new in that stuff.
I connected a web source like in this tutorial and it works fine so far:
feature
My issue is now, that the source is limmited on 10 lines and every day they add a new one, and delete the oldest one.
When I click in my excel on "refresh", I get a new download of all 10 new lines, but the old valued get lost as well.
Is it somehow possible, to extend my table in that way, that I keep the old values in my file?
Thank you upfront, I´m sorry, I´m not an native English writer. 🙂
See Answer
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
If you load the results to a worksheet, you can take the results table into a new query (this will be your archive, the oldest results), then combine it with the query from web.
The web query should ideally take only the newest entry, not all 10 lines, otherwise you will keep adding duplicates.
January 12, 2021
Offline
Hi,
this sounds good and plausible.
Did I do, as you suggested? (I´m not sure.)
I used as a source a stock, and the current values there, to get an update for each refresh.
In first step, I took values from web by power query like the tutorial and created my source table.
In a second step I created a "dublicate" of the first table, as a kind of archive.
In the third step, I changed the first table and added here as an applied step the second table.
Is that the corret way?
Is it possible, to keep just one table?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Close,
The result table can be read in the same query that reads the web:
let
Quelle = Web.Page(Web.Contents("https://www.ariva.de/tecdax")),
Data0 = Quelle{0}[Data],
OldData = Excel.CurrentWorkbook(){[Name="external_source"]}[Content],
#"Geänderter Typ" = Table.TransformColumnTypes(Data0,{{"Column1", type text}, {"Column2", Int64.Type}, {"Column3", Percentage.Type}, {"Column4", type text}, {"Column5", type number}, {"Column6", Percentage.Type}}),
#"Beibehaltene erste Zeilen" = Table.FirstN(#"Geänderter Typ",1),
#"Angefügte Abfrage" = Table.Combine({#"Beibehaltene erste Zeilen", OldData})
in
#"Angefügte Abfrage"
Answers Post
1 Guest(s)
