Joining a previously loaded table with a web-file?

[stjernvd]

Hi,

I recently decided to add a web-file from yahoo finance, listing some stock information.

Microsoft:

LOAD @1 as Info1,

     @2 as Values1

FROM

[http://finance.yahoo.com/q?s=MSFT&ql=0]

(html, codepage is 1252, no labels, table is @2);

I have an older table loaded from an excel file:

Original:

LOAD

  RowNo() as Row,

  Stock,

     Day,

     Month,

     Year,

     Close,

     [No. of Shares],

     [Stock Value]

FROM

(ooxml, embedded labels, table is [Stock Value]);

Which gives me this list box:

I would like to add the dimension 'Stock' to my Microsoft table from my web-file, so a column that says Microsoft across all values so that when I click on the different stocks in the list box, it would sort through the different web-file information for each stock. For now, all I have is each individual stock table, I want one big table where I can sort for stock.

Is this possible to add a new column from another table into a new web-file table?

Danielle

[sunny_talwar · Accepted solution]

Not sure I understand, but may be this:

Microsoft:

LOAD @1 as Info1,

     @2 as Values1,

     'Microsoft' as Stock

FROM

[http://finance.yahoo.com/q?s=MSFT&ql=0]

(html, codepage is 1252, no labels, table is @2);

[stjernvd]

Hi that worked perfectly, clearly it wasn't as hard as i thought:)

thank you!

[sunny_talwar]

Hahahaha ya

I am glad it worked.

Best,

Sunny