combining the data from different sources

[#1]

Hi Friends,

i am having two months of data as my source(xls)..i want to show two months data in my chart in two columns.

here my problem is every month data comes from three excels.

for example, if i want to show November data i have to consider

Nov_IR dump,

Nov_FX dump,

Nov_COA dump,  same for December also.

three dumps are having different data, but fields will be same in the two months data.

if i will concatenate i am getting data for two months in different different charts...

if i want to show the two months data in a single chart, what i have to do?

please help me..

sorry i am not able to upload the qvw ...

Thanks,

Sowmya

[#2]

Any Idea?

[PradeepReddy]

Concatenate the 2 tables, by adding one column with month name  which you can take it from input file.

In charts,

out of 2 dimensions one should be month and other would be your requirement.

consider one expression.

if still not satisfied with the result, post the sample output that you are  looking for?

[#4]

Hi Pradeer,

thank you for the reply,

for each date i will get data from the three dumps.

fields are same but data will be different..

here one more problem i can't concatenate the third dump with other two also, because of it do not have date field and one more thing is in dump1 also currency field is there so it will combine with that and will give wrong result.

here i am having two dates, i am creating charts for individual dates.

please find the attachments