Loading a table with two YEAR values

[FionnM]

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.

[FionnM · Accepted solution]

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;