concatenate

[soniasweety]

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

[pathiqvd · Accepted solution]

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,

[kaushiknsolanki]

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

[tresesco]

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)

[soniasweety]

thanks all ,I will check and update you

[soniasweety]

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?