join problem

[#1]

hi gurus,

i have 3 excel files.

1. f1,1/1/2012

2.f1,1/1/2012

3.f1,1/1/2012

f1= sales,revenue,% diff

1/1/2012=numbers which are corresponding to sales,revenue,gross.

structure example:

f1            1/1/2012

sales       $1000

revenue    $2000

diffin %    50%

how can i load 3 excels to associate each other

plz help me to achieve the desired result.

Thank u in advance

[jagan · Accepted solution]

Hi,

If all the 3 files has the same structure , then concatenate all the tables into one.

TableName:

LOAD

*

FROM File1;

CONCATENATE

LOAD

*

FROM File2;

CONCATENATE

LOAD

*

FROM File3;

Regards,

Jagan.