5 Replies Latest reply: Aug 10, 2017 9:34 AM by sony sing RSS

    concatenate

    sony sing

      Hi all,

      Tresesco B

       

      I have small confusion in data.

       

      I have two tables and in botht the tables I have some fields as same and some other different fields.

       

      my req is:  1.  one dashboard I need to show count of both values based on some field,

       

      2. I want to show separate table count values.

       

       

      how to show?

       

       

       

       

       

       

      3 bas charts

       

       

       

       

       

       

      example:

      1.count of company both=18

      in one report

       

       

      2.count of mi =9

      separate MI report

       

       

      3.count of md=9

      separate MD report

       

       

       

       

       

       

       

       

       

        • Re: concatenate
          lakshmipathi p

          Hi,

           

          Try like this,

           

          MI:

          Load *,'MI' as Flag from MI_Table;

          Concatenate

          MD:

          Load *,'MD' as Flag from MD_Table;


          chart1:-  count({<Flag=>}Company)

          chart2:-  count({<Flag={"MI"}>}Company)

          chart3:-  count({<Flag={"MD"}>}Company)



          Regards,

          • Re: concatenate
            Kaushik Solanki

            Hi,

            You can do a simple concatenate like below.

             

            Load *,'A' as Source from Table A;

            Concatenate

            Load *,'B' as Source from Table B;


            For 1 Chart just count the Company.

            For 2 Chart use set analysis to filter to source A

            For 3 Chart use set analysis to filter to source B

             

            Regards,

            Kaushik Solanki

            • Re: concatenate
              Tresesco B

              Try loading the tables like:

               

              T1:

              Load

                        *,

                        1 as flag

              From <>;

              Concatenate

              Load

                        *,

                       2 as flag

              From <>;

               

              Now in the front-end,

               

              Dim=Company

              For All company report : =Count(Model)

              For First table company report : =Count({<flag={1}>}Model)

              For Second table company report : =Count({<flag={2}>}Model)

                • Re: concatenate
                  sony sing

                  if I have the column names are different but inside values are same   how can I get join and use?

                   

                  example:   1st table column name :company 

                  2nd table  columnname :business       I need to combine count I want to show  how to map this?

                • Re: concatenate
                  sony sing

                  thanks all ,I will check and update you