appending two excel files. into one.

[ksk2]

Hi,

I am calling two Excel Files in to BO and when i download records of 2nd file should append with 1st files.

ex:. File1 is having

No Name Sal
________________________________________

10 aaa 100
20 bb 300
40 eee 200


File2 having

No Name Sal
________________________________________

41 qqq 0987
7 alk 90



And when I Download the file into excel then my file should be as below

No Name Sal
________________________________________
10 aaa 100
20 bb 300
40 eee 200
41 qqq 0987
7 alk 90


Thanks in advances

 

[PAULSGS]

Looks to me like you need the Union operator in your query

This will generate sql like this

Select No,Name, Sal from File1
Union
Select No,Name, Sal from File2

To do this, start a query, and build the first part against file 1
then press the "combine queries" icon (looks like yellow & blue balls). This creates a second query, which you may have to change the object selected to point at the second excel file

Union queries must have the same number of columns in each part and the columns that are combining must be of the same type

 

[blom0344]

Hello ksk2 and Paul,

Using Excel as a dataprovider does not give you the possibility of using query panel, cause there is no SQL generated to retrieve data. Union queries are a good approach for data retrieved in the usual way, namely by universe. The best approach in this case is to merge the data before it is loaded into BO. Otherwise you still wind up with data in two separate tables as far as I can figure. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[ksk2]

Hi Blom and Paul,

Thank for spending time on my Query..

Actually users are expecting one multiple files into single Excel file.So iam searching the way to give the Excel file .

As a BO reports Developer i can't suggest them to append every thing manually..

Any suggestions how to append two files in to one other then manual work?


Thanks and Regards
KSK2