Comparison of fields from two excel files....URGENT

[#1]

Hi all,

I created an application , in which I took multiple files of excel. Please find sample data in attachments.

As per attachments,

I extracted date and year from file name as project date and project year which I am using as filters.

I want to create a new column 'Status' in straight table and  wanna compare X1,X2,X3,X4 of the latest two files .If the data is same it should show as 'Same' else 'Changed'.

I wonder how can I compare two latest files in expressions. Please help me with this.

Any help would be appreciated.

Thanks in advance

PS:All excel sheets are of same format and same column names. As this is very urgent I am reposting with more clear data

Regards,

Priya

[#2]

Hi,

What are your Dimmensions of straight table? What link/connection it is between dimmension and import file?

I think isn't any connection .

This is a script-part to verify if a line is same or not(Maybe you configure again your problem).

tab1:

load

Project,

x1,

x2,

x3,

x4

from [....xls];   //first file

left join

load

Project,

x1 as x1_2,

x2 as x2_2,

x3 as x3_2,

x4 as x4_2

from [....xls];   //second file

tabresult:

Load *,

if(x1<>x1_2 OR x2<>x2_2 OR x3<>x3_2 OR x4<>x4_2 ,'Changed','Same') as Status

Resident tab1;

Drop tab1;