Hey guys and girls,
great Forum - already learned a lot from all of you.
I have a tricky question concerning WebQuery where I already tried a lot but failed miserably. Now I'm hoping you might have got some clues on how to handle that.
A Table on a website gives me Products and Prices. Depending on the day I query that Webpage, the title for the columns where the Products are listed changes. Sadly it contains the information how many lines actually are in the table. So on one day the columnheader could be "37 Products" and on the next day "39 Products" - in the same URL....
As I want to have an excelfile where I grab the data everyday and expand the table with certain Formulas, I get the Problem, that the Tablecolumn itself of course changes too. Is there a way in Power Query to set a column to a certain Name without static columnname? Because if I rename a column it looks like this: Table.RenameColumns(#"Geänderter Typ",{{"37 Products", "Products"}}). Is there a way to avoid this static "37 Products" and replace it with a columnnumber?? Or is there any other option like inserting a new line as columnheader?
Hope I explained it well enough and there are some hints. I would be very greatfull indeed.
BR
great Forum - already learned a lot from all of you.
I have a tricky question concerning WebQuery where I already tried a lot but failed miserably. Now I'm hoping you might have got some clues on how to handle that.
A Table on a website gives me Products and Prices. Depending on the day I query that Webpage, the title for the columns where the Products are listed changes. Sadly it contains the information how many lines actually are in the table. So on one day the columnheader could be "37 Products" and on the next day "39 Products" - in the same URL....
As I want to have an excelfile where I grab the data everyday and expand the table with certain Formulas, I get the Problem, that the Tablecolumn itself of course changes too. Is there a way in Power Query to set a column to a certain Name without static columnname? Because if I rename a column it looks like this: Table.RenameColumns(#"Geänderter Typ",{{"37 Products", "Products"}}). Is there a way to avoid this static "37 Products" and replace it with a columnnumber?? Or is there any other option like inserting a new line as columnheader?
Hope I explained it well enough and there are some hints. I would be very greatfull indeed.
BR