Resident Load Error

[#1]

Hello Friends

Below is my piece of code

lTest:

Load *,

[Temp ID] as [New Temp ID]

from lTest.qvd(qvd);

MxTemp:

Load * ,max([New Temp ID] as [New Temp ID]) ,[Orig Temp ID]

Resident lTest group by [Orig Temp ID];

The error  I am getting says field names must be unique within Tale.  This error pops up when about to load Temp. But If I want all my columns isnt Load * from resident the right way? Because I will be dropping the lTest Table and later will be fropping the MxTemp Table when I use it as a resident for another table.

Thoughts?

Thanks

Rizwan

[#2]

Hello Sunny

I cant share the exact script.

This is a sample of it

Thanks

[#3]

Hello Sunny

This is what I want to achieve

I need to get the last part of it (exists ) to work.

lTest:

Load * from lTest.qvd(qvd);

Right Join(lTest)

Load [Orig Temp ID],max([Temp ID]) as [Max Temp ID]

Resident lTest Group By [Orig Temp ID]

;

Temp:

LOAD * Resident lTest where exists ([Max Temp ID]) and exists ([Orig Temp ID]);

drop table lTest;

Store Temp into Temp.qvd;

[marcus_sommer]

I see you want to filter this table but it's not quite clear for me what should be filterred. Please provide a small example with a few inline-data.

- Marcus