Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I get an error for anything that goes after
load UPPER(OSuser()) as NTuser;
in my script. When I remove that line all is fine. Any ideas?
Thnx
Mat
Can you provide the complete script please?
Sure:
load UPPER(OSuser()) as NTuser;
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
Let NumOfYears = $(YearsBack) + $(YearsForward) + 1;
Let NumOfMonths = $(NumOfYears)*12;
Let NumOfDays = $(NumOfYears)*365;
Let StartYear = Year(floor(now())) - $(YearsBack);
Let StartDate = Num(MakeDate($(StartYear),$(FiscalMoShift)+1));
Let LastDateKey= Date(floor(now()),'MM-DD-YYYY');
Date_src:
LOAD
$(StartDate) + iterno()-1 as DateStamp autogenerate 1 while iterno() <= $(NumOfDays) + 1;
Dates:
LOAD Distinct
DateStamp,
date(floor(DateStamp)) as DateKey,
day(DateStamp) as Day,
month(DateStamp) as Month,
year(DateStamp) as Year,
num(Month(DateStamp) + (Year(DateStamp) - $(StartYear))*12) as MonthNum,
Date(DateStamp,'MMMYY') as MonthYr,
Dual('Q' & ceil(((mid(date(DateStamp,'YYYY-MM-DD'),6,2)))/3), ceil(((mid(date(DateStamp,'YYYY-MM-DD'),6,2)))/3)) as Qtr,
if(weekday(DateStamp)>4, 0,1) as WorkDay
Resident Date_src;
You have no table to load from.
Use this instead:
LET NTUser = UPPER(OSuser());
That should be good for you.
Thanks. Now, I'm trying the following script, which does not work:
LET NTUser = UPPER(OSuser());
ConfigUsers:
LOAD * INLINE [
NTuser, NTuserGroup
MYDOMAIN\PPAN, Executive
MYDOMAIN\RTHAT, Executive
];
Config:
load NTuser, NTuserGroup
resident ConfigUsers where NTuser='$(NTUser)';
drop table ConfigUsers;
Any help appreciated!
Mat
Please use this:
LET NTUser = UPPER(OSuser());
ConfigUsers:
LOAD * INLINE [
NTuser, NTuserGroup
MYDOMAIN\PPAN, Executive
MYDOMAIN\RTHAT, Executive
];
Config:
NoConcatenate
load NTuser, NTuserGroup
resident ConfigUsers where NTuser='$(NTUser)';
drop table ConfigUsers;
Let me know if it works or not.
Sweet. Works nicely. Thnx!
Can we use Config: table as Mapping Load??