Add a new column in table

[#1]

Hello,

I have this table and i want to add a new column  next 2015 with as value (SL(2015) - Sl(2014))-1.

Thks in advance

[#2]

it doesn't work cause they don't have a same key

[sunny_talwar]

I had to put a replace because I didn't have access to the source data file. So I added a Replace to do a partial reload. The idea is you need to concatenate another value to your Year field. So in essence a Year list box will look something like this:

Because I forcefully (using concatenation) added Diff value to the Year field.

In the attached file script, change the scrip to this:

Periode:

LOAD Year

FROM

C:\Users\babacar.sow\Desktop\Classeur1.xlsx

(ooxml, embedded labels, table is Feuil1);

Ventes:

LOAD Year,

    Sales

FROM

C:\Users\babacar.sow\Desktop\Classeur1.xlsx

(ooxml, embedded labels, table is Feuil2);

Concatenate(Periode)

LOAD * Inline [

Year

Diff

];

HTH

Best,

Sunny

[#4]

Sorry, but it doesn't work so.

I have to find another way