7 Replies Latest reply: Sep 2, 2015 3:43 AM by arjun rao RSS

    Add one field with fixed values

    vir vir

      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.

        • Re: Add one field with fixed values
          Gowtham Kesavan

          can you post some sample data

          • Re: Add one field with fixed values
            Petter Skjolden

            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

            • Re: Add one field with fixed values
              Kalyan Navuluri

              add this line in your script,

               

              'SRF_MMMYYYYConference' as new_field


              then add this field in straight table

              • Re: Add one field with fixed values
                Sunny Talwar

                This is needed to be added in the script or on the front end of the application?

                • Re: Add one field with fixed values
                  Sasidhar Parupudi

                  if you have YYYYMM as a dimension,

                   

                  add a calculated dimension in the straight table like below

                   

                  ='SRF_' & YYYYMM&'Conference'

                   

                  hth

                  Sasi

                  • Re: Add one field with fixed values
                    arjun rao

                    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

                    ];

                     

                    Capture.JPG

                     

                    //='SRF_' & YYYYMM&'Conference'