Discussion Board for collaboration related to QlikView Deployment.
I m using this trick for order by.
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?
Please check the spelling in your example code. Field names don't match, and you have two FROM clauses in the first load.
I dont get why are you renaming the temp table is it too much needed
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....