Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I m using this trick for order by.
Maintable:
LOAD
filed1,
filed2,
field3
from
FROM
netadd_from_mindate_to_tilldate.qvd(qvd);
temp:
NoConcatenate
Load * resident Maintable
order by field1, filed2 ;
drop table Maintable;
rename table temp to Maintable;
store Maintableinto 'D:\reruntesting\Data\RawQvds\Maintable.qvd';
But this is giving error like
"Field not found temp:"
Can anyone please tell what mistake i m doing?
Thanks
Please check the spelling in your example code. Field names don't match, and you have two FROM clauses in the first load.
Best,
Peter
I dont get why are you renaming the temp table is it too much needed
Thanks Peter,
i really ashamed on asking this type of stupid question. I should take care of these things.
It was typing mistake.
Yeah! you are right, actually its not required to rename.
check your spell i.e field1 or filed1 for this so, remove this error and might be helpful for you....