Loading a table with two YEAR values

FionnM — Mon, 14 Nov 2022 10:03:49 GMT

I have an Excel spreadsheet with three columns, "In Year", "Out Year" and "Cumulative Inflation". It looks like this:

IN YEAR OUT YEAR CUMULATIVE INFLATION

2016 2023 1.6718

I want to load it in my script so that it parses the values in "In Year" and "Out Year" as years, and associates each unique combination of "In Year" and "Out Year" with a specific value for "Cumulative Inflation" (e.g. if the "In Year" is 2016 and the "Out Year" is 2023, the "Cumulative Inflation" is 1.6718).

So far my script looks like this:

LOAD [IN YEAR] as [In Year], [OUT YEAR] as [Out Year], [CUMULATIVE INFLATION] as [Cumulative Inflation] FROM [C:\QlikviewServer\CCD\Sources\Cumulative inflation.xlsx] (ooxml, embedded labels, table is Sheet1); m: mapping load date(date#("In Year", 'YYYY')), [Cumulative Inflation]; Resident Sheet1;

I can't figure out how to load the "Out Year" column at the same time as the "In Year" column.

Re: Loading a table with two YEAR values

FionnM — Mon, 14 Nov 2022 10:07:47 GMT

Figured it out literally thirty seconds after I posted this, I just needed to include a second line under the last line.

m: mapping load date(date#("Out Year", 'YYYY')), [Cumulative Inflation]; Resident Sheet1;

topic Re: Loading a table with two YEAR values in QlikView

Loading a table with two YEAR values

Re: Loading a table with two YEAR values