selection new row in different table

[Anonymous]

Hi,

i've two straight tables with same columns but in the second one i've new record. I would to highlight those new record by color text or background.

Source code from sql db

Image example following

Thank you

[felipedl · Accepted solution]

Hi federico,

Using the following script:

table1:

LOAD * Inline

[

TABLE1

name1

name2

name3

name4

];

table2:

LOAD * Inline

[

TABLE2

name1

name2

name666

name676

];

left join (table2)

load

TABLE1 as TABLE2,

1 as [Flag TABLE1]

Resident table1;

Concatenate(table1)

Load

TABLE2,

[Flag TABLE1]

Resident table2;

drop table table2;

data:

Load

TABLE1,

TABLE2,

[Flag TABLE1],

if(not IsNull(TABLE2) and IsNull([Flag TABLE1]),1,0) as [Flag New Record]

Resident table1;

drop table table1;

You'll get the new records you want.

Attached the QVW I used and result on the below picture.

[Anonymous]

I cannot join two table, i should be work by dimension and expression formula.

Thanks