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

[avinashelite]

could you please share the sample data ?? it will help us to understand the data

[Anonymous]

Fields/Column name in

Nov_IR dump,

Nov_FX dump,

Nov_COA dump is same???

If yes, did you try like this,

Final_Data:

load *

'Nov' as Flag

from Nov*;

//For Dec

Load

*,

'Dec' as Flag

from Dec*;

If you do like this, hope you will be able to achieve what you are looking for..

[Chanty4u]

try to do inner join

[Anonymous]

two months in different different chart means?

share a snapshot of that..

[Chanty4u]

or Qualify use

[PradeepReddy]

Please post the sample data..

[#8]

Hi,

i am having the source and data as below...

Dec4:	Dec11:
LOAD DataDate,	LOAD DataDate,
date(DataDate,'DD/MM/YYYY')as Date,	date(DataDate,'DD/MM/YYYY')as Date,
Portfolio,	Portfolio,
Nett,	Nett,
FROM	FROM
LOAD	LOAD
Date( Date#(Date,'YYYYDDMM'),'MM/DD/YYYY') as Date,	Date( Date#(Date,'YYYYDDMM'),'MM/DD/YYYY') as Date,
Quotation,	Quotation,
Bid,	Bid,
Ask,	Ask,
Mid	Mid
FROM	FROM
COA:	COA:
LOAD [Stratification Audit],	LOAD [Stratification Audit],
If(len(trim(E))>0, E,If(len(trim(E))=0,If(len(trim(D))>0, D,If(len(trim(D))=0,peek('COA'),If(len(trim(C))>0,C)))))as COA,	If(len(trim(E))>0, E,If(len(trim(E))=0,If(len(trim(D))>0, D,If(len(trim(D))=0,peek('COA'),If(len(trim(C))>0,C)))))as COA,
H as Currency,	H as Currency,
I as FaceAmount,	I as FaceAmount,
FROM	FROM

i want to show these two dates data in two columns in my chart? how i can?

thanks...

[#9]

Hi,

i am having the source and data as below...

Dec4:	Dec11:
LOAD DataDate,	LOAD DataDate,
date(DataDate,'DD/MM/YYYY')as Date,	date(DataDate,'DD/MM/YYYY')as Date,
Portfolio,	Portfolio,
Nett,	Nett,
FROM	FROM
LOAD	LOAD
Date( Date#(Date,'YYYYDDMM'),'MM/DD/YYYY') as Date,	Date( Date#(Date,'YYYYDDMM'),'MM/DD/YYYY') as Date,
Quotation,	Quotation,
Bid,	Bid,
Ask,	Ask,
Mid	Mid
FROM	FROM
COA:	COA:
LOAD [Stratification Audit],	LOAD [Stratification Audit],
If(len(trim(E))>0, E,If(len(trim(E))=0,If(len(trim(D))>0, D,If(len(trim(D))=0,peek('COA'),If(len(trim(C))>0,C)))))as COA,	If(len(trim(E))>0, E,If(len(trim(E))=0,If(len(trim(D))>0, D,If(len(trim(D))=0,peek('COA'),If(len(trim(C))>0,C)))))as COA,
H as Currency,	H as Currency,
I as FaceAmount,	I as FaceAmount,
FROM	FROM

i want to show these two dates data in two columns in my chart? how i can?

thanks...

[#10]

I can able to crate two charts using Qualify as suresh told....

but i want show these two dates data into single chart..

please help me