Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to add 1 field in the straight table and the field value is "SRF_MMMYYYYConference" .
Kindly suggest how can i add this field value in the table and this value we have to add from our end .
other than MMMYYYY , we have to hardcode complete value.
Kindly suggest.
can you post some sample data
In the UI you can simply have the expression like this:
'SRF_' & vDateVariable & 'Conference' if referring to a variable that contains the date
or
'SRF_' & Min(ConfDate) & 'Conference' if the conference date is associated with the dimensions in a meaningful way
add this line in your script,
'SRF_MMMYYYYConference' as new_field
then add this field in straight table
This is needed to be added in the script or on the front end of the application?
if you have YYYYMM as a dimension,
add a calculated dimension in the straight table like below
='SRF_' & YYYYMM&'Conference'
hth
Sasi
Hi vir vir,
Please use the below script:
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 DateFormat='YYYYMM';
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';
Emplyee:
Load *, 'SRF_' & Date &' Conference' as NewDate;
load EMPNO, ENAME, JOB, MGR, date(HIREDATE) as Date, SAL, COMM, DEPTNO inline [
EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO
7369, SMITH, CLERK, 7902, 1980-12-17 00:00:00.000, 800.00, NULL, 20
7499, ALLEN, SALESMAN, 7698, 1981-02-20 00:00:00.000, 1600.00, 300.00, 30
7521, WARD, SALESMAN, 7698, 1981-02-22 00:00:00.000, 1250.00, 500.00, 30
7566, JONES, MANAGER, 7839, 1981-04-02 00:00:00.000, 2975.00, NULL, 20
7654, MARTIN, SALESMAN, 7698, 1981-09-28 00:00:00.000, 1250.00, 1400.00, 30
7698, BLAKE, MANAGER, 7839, 1981-05-01 00:00:00.000, 2850.00, NULL, 30
7782, CLARK, MANAGER, 7839, 1981-06-09 00:00:00.000, 2450.00, NULL, 10
7788, SCOTT, ANALYST, 7566, 1982-12-09 00:00:00.000, 3000.00, NULL, 20
7839, KING, PRESIDENT, NULL, 1981-11-17 00:00:00.000, 5000.00, NULL, 10
7844, TURNER, SALESMAN, 7698, 1981-09-08 00:00:00.000, 1500.00, 0.00, 30
7876, ADAMS, CLERK, 7788, 1983-01-12 00:00:00.000, 1100.00, NULL, 20
7900, JAMES, CLERK, 7698, 1981-12-03 00:00:00.000, 950.00, NULL, 30
7902, FORD, ANALYST, 7566, 1981-12-03 00:00:00.000, 3000.00, NULL, 20
7934, MILLER, CLERK, 7782, 1982-01-23 00:00:00.000, 1300.00, NULL, 10
];
//='SRF_' & YYYYMM&'Conference'
Let us know if you get any issues. Thank you.