Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Sunny
I cant share the exact script.
This is a sample of it
Thanks
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;
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