Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
See if this can help based on front end changes -
Thanks sandip
Thanks Jagan
Thanks Digvijay
Hi,
If you got the answer close this thread by giving correct answer.
Regards,
jagan.
No luck..Still looking for correct answer