I'm trying to decipher the following code. The description says that the temporary table allows sorting without adding a separate sorting field or using "DUAL":
TempPreSort: // creating temporary table with pre-sorted fields
Load * Inline [
Products: // Loading in data
From [$(Desktop)\Products.xls] (biff, embedded labels, header is 1 lines, table is [Sheet1$]);
Drop Table TempPreSort
- Does TempPreSort affect Products load at all? Should data in Products be grouped/ordered according to the order defined in TempPreSort ?
- If TempPreSort affect Products load ..
- does TempPreSort have to be created before Products load?
- would any grouping/ordering be removed when TempPreSort is dropped immediately after Products load?