Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.