6 Replies Latest reply: Jun 29, 2011 7:00 AM by Kaushik Solanki RSS

    Creating a new field value

      Hi guys,

       

      I have an interesting question and I hope someone can help me out with this.

       

      I have a field called Location that has the following string values StringValue 1, StringValue 2, StringValue 3.

       

      I would like to create a new field value called StringValue4 based on StringValue1 and StringValue 2 and add it to the original field so that my new field values would be StringValue 1, StringValue 2, StringValue 3 and StringValue 4.

       

      I do not know if this is actually possible, but if it is, I would appreciate help on this.

       

       

      Thanks

        • Creating a new field value
          Kaushik Solanki

          Hi,

           

             Try this way,

           

             Data:

              Load

             Loaction

              From xyz;

           

             load

             if(Location = StringValue1,'Matched','Not Matched') as Location

              Resident Location;

           

             I hope you got. If not provide the qvw file.

           

          Regards,

          Kaushik Solanki

            • Creating a new field value

              Hi Kaushik,

               

              I do not think that will give me what I am looking for, as that does not create a new field value in the way I require

               

              Just for clarity, this is what I want

               

              Field

              StringValue 1

              StringValue 2

              String Value 3

               

              New Field

              StringValue 1

              StringValue 2

              StringValue 3

              StringValue 4

               

              When I now use New Field in a chart dimension, it should return 4 possibilities instead of 3.

               

              Thanks

                • Creating a new field value
                  Kaushik Solanki

                  HI,

                   

                      Can you tell me how you want your 4th value to be generated.

                   

                      I mean what calculation you want to do to get 4th value.

                   

                  Regards,

                  Kaushik Solanki

                    • Re: Creating a new field value

                      Let me provide some code for clarity.

                       

                      I have tried this out and it is almost there, but not quite there yet.

                       

                      IF(Area = 'GA', 'GA',   

                              IF(Area ='F', 'F',              

                                  if(Area = 'P', 'P',                      

                                      if(Location='B' OR  Area = 'C' OR Area = 'Comp'   OR Area = 'D' OR Area=  'F' OR Area ='GA'    OR Area = '','Total'))))

                       

                      Now the problem is that before the if statements assigns values to Total, the values are already used by GA and F, so the Total value does not give the right Total, but only gives the value for Comp, C, P and B. I want the Total value to be the sum of everything.

                       

                      How can I get that to work?

                       

                       

                      Thanks

                        • Creating a new field value
                          Kaushik Solanki

                          HI,

                           

                             What i can understand from this is you want a forth field to have a value "Total" when the area is C/Comp/D/F/GA and location is B.

                           

                             If this is what you want then you have done the right thing,

                           

                             If not then please tell me with example what you have and what you desire.

                           

                          Regards,

                          Kaushik Solanki

                      • Creating a new field value
                        Nagaian Krishnamoorthy

                        If your field 'location' has three field values always, is it possible to load these values in three fields (location-1, location-2, and location-3)?

                         

                        If that is possible, you can generate the fourth value (as the fourth field, location-4) by left join.