The fastest way is instead
source:
LOAD *,
IsNum(left("Pre-W2K Name",7)) as MatriAccounts,
Match(Mid("Pre-W2K Name",8), 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm',
'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', 'x', 'y', 'z',
'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M',
'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z' )
as MatriculeAccounts;
LOAD
"Pre-W2K Name"
FROM [lib://AD Dashboard/AD-DATA-01.06.2017.xlsx]
(ooxml, embedded labels, table is Sheet1);
NoConcatenate
Output:
LOAD *
RESIDENT source
WHERE MatriAccounts =-1 AND MatriculeAccounts >0;
DROP table source;
May be like this
LOAD
"Pre-W2K Name"
FROM [lib://AD Dashboard/AD-DATA-01.06.2017.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where Left([Pre-W2K Name-], 4) = 'ADM_' And RangeSum(Num(Mid([Pre-W2K Name-], 5, 6)))>0;
It all depends on what you want to get in the first table and what in the [Output] table, as well as how they should be related (if they should). Only by cod...
May be fragment of source data and what you wont to get in result?
