11 Replies Latest reply: Aug 22, 2018 11:15 AM by shekar shekhar RSS

    Help me to code script for merging multiple records with condition ?

    Prahlad Infy

      HELLO SIRS ,

       

      Please help me on the below output to get ,

       

      Merging with condition.PNG

       

      Combination to Get Final Field

       

      IF TIER IS = O  AND Area is Geologics then Final Field will be Geological

      IF TIER IS = Z   AND Area is Growth then Final Field will be Growth

      IF TIER IS = B   AND Area is Fashion then Final Field will be Fashion

      IF TIER IS = A   AND Area is Fashion then Final Field will be Textile Technology & Fabrics

       

      Data :

       

      Data:

      LOAD * INLINE [

          Conference_Id, Date, Speaker, Area, Tier, Company, Room_Nbr

          108-23-6686, 22-08-2017, Pernell Vayne, Climate, Tier C, Riffpath, Ball Room 6

          108-23-6686, 22-08-2017, Jeannine Wickett, Geologics, Tier O, JumpXS, Ball Room 6

          108-23-6686, 22-08-2017, Israel Davidson, History, Tier C, Tagchat, Ball Room 6

          108-23-6686, 22-08-2017, Ed MacCarlich, Climate, Tier C, Wikizz, Ball Room 6

          108-23-6686, 22-08-2017, Gerri Elbourne, Climate, Tier C, Feedfire, Ball Room 6

          108-23-6686, 22-08-2017, Adan Anthonsen, Geologics, Tier O, Fiveclub, Ball Room 6

          500-37-5569, 23-08-2017, Rhea Tuxell, Inflation, Tier X, Kare, Ball Room 7

          500-37-5569, 23-08-2017, Pernell Vayne, Inflation, Tier X, Thoughtsphere, Ball Room 7

          500-37-5569, 23-08-2017, Jeannine Wickett, Jobs, Tier Q, Youbridge, Ball Room 7

          500-37-5569, 23-08-2017, Israel Davidson, Growth, Tier Z, Blogtags, Ball Room 7

          108-23-6689, 24-08-2017, Cordelia Brunt, Fashion, Tier B, Blognation, Ball Room 11

          108-23-6689, 24-08-2017, Ed MacPEARSON, Textile, Tier A, Aimbu, Ball Room 11

          500-37-2222, 25-08-2017, Ceciley Cushion, Growth, Tier X, Blogtags, Ball Room 1

          500-37-2222, 26-08-2017, Gracia Cheek, Fashion, Tier A, Blognation, Ball Room 1

          500-37-2222, 27-08-2017, Cale Curuclis, Textile, Tier A, Aimbu, Ball Room 1

      ];

       

      I have mereged the records but how to get last field ?

       

      Thank you