Get Data from Web | how do I add information?

[PoweRRob]

Hi!


Today I tried the "Get Data from Web" function for the first time and it actually works very well. However, I can't figure out how to add some extra labels to the data.

In this case, I loaded in some information (price increase/decreased) for six different stocks. I loaded them in one by one - as their information is on different pages of a website - and then combined the queries. So far, so good. 

However, I want to include the name of the stock in the table. It is not in the table that i load from the website, but i can't find a way manually add it to the table. To clarify, i want to get the names (Stock A till F) in the colom 'Names'. I can't make it happen, for some reason.. I'm probably missing something very obvious, but i can't get my head around.

Thanks in advance!

[v-jiascu-msft · Accepted solution]

Hi @PoweRRob,

Since you said you can add them manually, I would suggest you try as the snapshot shows.

1. Add an index due to we can't identify the rows programmatically.

2. Add a Conditional Column with as many rules as you want. 

Best Regards,

Dale

[PoweRRob]

Worked perfectly, thank you!

[Greg_Deckler]

Well, if each page is a stock name then in each query add a new custom column and just make the column equal to "Stock A" for the first one, "Stock B" for the second one, etc. Make sure all of the new columns that you add to each query are named identical. Then, when you combine them (I'm assuming an Append Query) then these new columns should come through as well.