Need Consistent data

[#1]

Hi

I have two files with same data(few fields).But both don't have same hierarchy.I want to make it hierarchy consistent and if any different values are there then I need to highlight the difference.

File1 :                                    

field1  field2

A         11

B         22

C         33

D         44

file2:

field1  field2

A         11

B         22

C         33

D         55

D value should be highlight.Please help asap

Thanks

[Anonymous]

try this....

Load your data using below script:

File1 :                                   

LOAD * INLINE [

field1,  field2

A,         11

B,         22

C,         33

D,         44]

;

QUALIFY field2 ;

file2:

NoConcatenate LOAD * INLINE [

field1,  field2

A,         11

B,         22

C,         33

D,         55

];

Create one straight table use Field 1 as dimension

and expression will be:

1) only(field2)

2)only(file2.field2)

3)if(Column(1)=Column(2),'NO' ,'Yes')

in the background color of expressions and dimension use below code:

=if(Column(1)=Column(2),'NO',Green())

out put will be

[jagan]

Hi,

Try like this

File1 :

LOAD * INLINE [

field1,  field2

A,         11

B,         22

C,         33

D,         44]

;

File2:

NoConcatenate LOAD * INLINE [

field1,  field2_File2

A,         11

B,         22

C,         33

D,         55

];

Chart :

Dimensions: field1, field2, field2_File2

Expression: if(field2=field2_File2,'Yes' ,'No')

Background Color expression: =If(Column(1)='NO',RGB(255, 0, 0))

Hope this helps you.

Regards,

Jagan.

[Digvijay_Singh]

See if this can help based on front end changes -

[#5]

Thanks sandip

[#6]

Thanks Jagan

[#7]

Thanks Digvijay

[jagan]

Hi,

If you got the answer close this thread by giving correct answer.

Regards,

jagan.

[#9]

No luck..Still looking for correct answer