Hi, I'm trying to concatenate userMonthnum with Year, usermonth with Year, MonthNum with Year and Month with Year. However, a called field calls the original field from the load statement directly below. How can I concatenate those variables, looking at my current script below? The variables I want to concatenate is in bold. Thanks.
load *, userMonthNum &'/'& Year as uMonthNum,
usermonth &'/'& Year as uMonth,
MonthNum &'/'& Year as tMonthnum,
Month &'/'& Year as tMonth;
LOAD * INLINE [
userMonthNum, usermonth
01, Jan
02, Feb
03, Mar
04, Apr
05, May
06, Jun
07, Jul
08, Aug
09, Sep
10, Oct
11, Nov
12, Dec
];
LOAD * INLINE [
MonthNum, Month
01, Jan
02, Feb
03, Mar
04, Apr
05, May
06, Jun
07, Jul
08, Aug
09, Sep
10, Oct
11, Nov
12, Dec
];
load *, date([userPrint_Month],'MM') as userMonthNum;
load *,If(DESCRIPTION like 'U*' Or DESCRIPTION like 'u*',[Print Month]) as userPrint_Month,
date([Print Month],'MM') as MonthNum;
load *,date(MonthStart([Print Date]),'MM/YYYY') as [Print Month],
If(DESCRIPTION like 'U*' Or DESCRIPTION like 'u*',DESCRIPTION) as Description,
If(DESCRIPTION like 'U*' Or DESCRIPTION like 'u*',SITEID) as [Site ID],
If(DESCRIPTION like 'U*' Or DESCRIPTION like 'u*',PURCHASEAGENT) as [Purchase Agent],
If(DESCRIPTION like 'U*' Or DESCRIPTION like 'u*',REQUESTEDBY) as [Requested By],
Year([Print Date]) as Year;
LOAD
.
.
.
.
.
.
RFQNUM,
DESCRIPTION,
SITEID,
REQUESTEDBY
PURCHASEAGENT,
PRINTDATE,
date(floor(timestamp#(Replace([PRINTDATE],' ',' '), 'DD.MM.YYYY hh:ss:mm'))) as [Print Date]
FROM
<filename>
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);