Commentary

[bobbydave]

So I have two dynamic tables.

They both have a row called Country. Both tables display fine independently.

I want to add the Commentary row to the first table dependant on what Country it is. At the moment, for each Country, ALL the comments appear. I only want the the expression to show each comment for each corresponding country and not show all the comments per country

Table 1

Country	Header 2
UK	XX
IE	XX
ES	XX

Table 2

Country	Commentary
ES	Test
IE	Another test

I can't concatenate as there are 5 expressions using different tables in Table1.

Or can I?

Any help appreciated.

[kristoferahlin]

Hi,

It looks like your 2 Country fields are not linked in the data model. What if you use Country as key field to link the source tables? Or left join the commentary field into the first table.

Are you able to post a sample application?

Cheers,

Kristofer

[awhitfield]

Hi Bobbydave,

how are you adding the comments?

Andy

[ankitaag]

Hey bobby,

Find the attached qvw.

Thanks and Regards,

Ankita

[jsanchezh · Accepted solution]

You can join the commentary information to your first table:

left join(table1) Load     Country,

     Commentary

Resident table2;

Then you will have one table with all the information

[bobbydave]

These are my tables below.

There are some expressions made up using the tables below. The last table is the Commentary table. I just want to take the Comment and match it with the Country of the others. The tables make up one  table.

Nulls:
LOAD
Country & '-' & NULLS_Date as %Nulls_Detail,
Country  as Nulls.Country,
[Table Name],
[Column Name],
[Count Null],
[Count non-Null],

// if Column Name in Nullls and Column Name in Act_Materialfields_Map match, then
  

ApplyMap( 'Map_Completeness_Score', [Column Name], 'Error') as Y_Score,  //sum([Count non-Null])) as tests,
  
NULLS_Date,
NULLS_Country_Code
FROM

(qvd);




Logs:
LOAD
COUNTRY_CD & '-' & Logs_Date as %Logs_Detail,
COUNTRY_CD  as Logs.Country,
ACC_PERIOD,
HEAD_ROWCOUNT,
DETAIL_ROWCOUNT,
TIA_CLAIMS,
Logs_Date,
Logs_Country_Code
FROM

(qvd);

GL_AUDIT:
LOAD
Country & '-' & GLA_Date as %GL_Detail,
Country  as GLA.Country,
Period,
[GL Rep46Proc],
[Claims Ext],
Difference,
[% Difference],
Outcome,
GLA_Date,
GLA_Country_Code
FROM

(qvd);


ERRS:
LOAD
ERRS_Country_Code & '-' & ERRS_Date as %ERRS_Detail,
CLA_CASE#,
ERRS_Date,
ERRS_Country_Code as ERRS.Country
FROM

(qvd);


Count_Value:
LOAD
Country & '-' & CV_Date as %CV_Detail,
Country as Count.Country,
Source,
Status,
[Claim Count],
[Total Claims Benefit],
CV_Date,
CV_Country_Code
FROM

(qvd);


[IT Commentary]:
LOAD Country & '-' & Commentary_Date as %IT_Commentary_Detail,
Country as ITComm.Country,
[IT Period] as ITCommPeriod,
Measure,
Comment,
[Mgt Action],
Commentary_Date,
Commentary_Code
FROM

(qvd);

KEY TABLE BELOW

KeyTable:
Load
%GL_Detail,
ApplyMap('Countries_MAP', GLA_Country_Code, 'MISSING') as [Country],
GLA.Country as [Country Code],
date(date#(GLA_Date, 'YYYY-MM')) as %KEY_Calendar

Resident GL_AUDIT;

Concatenate (KeyTable)
Load
%Logs_Detail,
ApplyMap('Countries_MAP', Logs.Country, 'MISSING') as [Country],
Logs.Country as [Country Code],
date(date#(Logs_Date, 'YYYY-MM')) as %KEY_Calendar

Resident Logs;

Concatenate (KeyTable)
Load
%ERRS_Detail,
ApplyMap('Countries_MAP', ERRS.Country, 'MISSING') as [Country],
ERRS.Country as [Country Code],
date(date#(ERRS_Date, 'YYYY-MM')) as %KEY_Calendar

Resident ERRS;


Concatenate (KeyTable)
Load
%Nulls_Detail,
ApplyMap('Countries_MAP', Nulls.Country, 'MISSING') as [Country],
Nulls.Country as [Country Code],
date(date#(NULLS_Date, 'YYYY-MM')) as %KEY_Calendar

Resident Nulls;

Concatenate (KeyTable)
Load
%CV_Detail,
ApplyMap('Countries_MAP', Count.Country, 'MISSING') as [Country],
Count.Country as [Country Code],
date(date#(CV_Date, 'YYYY-MM')) as %KEY_Calendar

Resident Count_Value;

Concatenate (KeyTable)
Load
%IT_Commentary_Detail,
ApplyMap('Countries_MAP', ITComm.Country, 'MISSING') as [Country],
ITComm.Country as [Country Code],
date(date#(Commentary_Date, 'YYYY-MM')) as %KEY_Calendar

Resident [IT Commentary];