Please Urgent Help Required

[VishalWaghole]

Hi Community,

Please Help me Its Very urgent.

I have Data into 2 different sheets Like

Sheet 1

WebTopNum	Type	OpenError
1111	PL	1
2222	BL
3333	BL	2

and Sheet 2

WebTopNum	Type	Status
1111	PL	Open
2222	BL	Closed

I want Output Like this

Type	Raised	Open
PL	1	1
BL	2

In Output file Raised means OpenErrors from sheet1 and Open means Status from sheet2.

Thanks and Regards,

Vishal Waghole

[#2]

Output:

LOAD

     Type,

     Status as Open

From Sheet1;

Left Join

LOAD

     Type,

     OpenError as Raised

From Sheet2

Where not IsNull(OpenError);

[abeyphilip]

Please see if the attached qvw helps.

[#4]

see attached file

output like this

.

Type	Raised	Open
PL	1	1
BL	2	0