NOCONCATENATE works to load my new table (myNewData; myNewData will be autoconcatenated to the myTemp table; after we use NOCONCATENATE , new table will not be dropped any more)
However, after I use [date(myDate) as myDateFormat; Resident myTemp Order By myDateFormat;], date is still not in order at Qlik. When I use date as dimension to create chart at Qlik, the date at dimension is still not in order (seems random). Any suggestion is appreciated!
I will be sure to update a sample file of my date problem.