topic Re: Joining a previously loaded table with a web-file? in QlikView

Joining a previously loaded table with a web-file?

stjernvd — Mon, 13 Jul 2015 14:15:22 GMT

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

Re: Joining a previously loaded table with a web-file?

sunny_talwar — Mon, 13 Jul 2015 15:20:44 GMT

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);

Re: Joining a previously loaded table with a web-file?

stjernvd — Mon, 13 Jul 2015 15:30:16 GMT

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

thank you!

Re: Joining a previously loaded table with a web-file?

sunny_talwar — Mon, 13 Jul 2015 15:32:01 GMT

Hahahaha ya

I am glad it worked.

Best,

Sunny