Hello All,
I am trying to use the data manager to sync my tables and then sort my field by 'Open', 'Working', then 'Closed' however whenever I use the Order tab in the field manager it changes my values to '?' in the sheet views. Example load script below. I am loading in a dual field which has repeating values due to another business constraint. Example tables below.
| SOURCE A | |
| Status_ID | Display |
| 1 | Open |
| 2 | Open |
| 3 | Working |
| 4 | Working |
| 5 | Closed |
| 6 | Closed |
| SOURCE B | | |
| Item | Item Status | User ID |
| A | 1 | 4326 |
| B | 2 | 4326 |
| C | 3 | 4326 |
| D | 4 | 4211 |
| E | 5 | 4211 |
| F | 6 | 4211 |
| G | 1 | 4875 |
| H | 2 | 4875 |
| J | 3 | 4875 |
[tmp_Status]:
LOAD DUAL(Display, Status_ID) AS [Item Status]
FROM SOURCE A;
[tmp_Main]:
LOAD *
FROM SOURCE B;
DROP TABLE [tmp_Status]
[Main]:
Load *,
TEXT([Item Status]) AS [Status]
RESIDENT [tmp_Main];
DROP TABLE [tmp_Main];
DROP Field [Item Status];
