Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Use if from tFileCompare to only send mail if boolean is false

Hi
I have a routine which uses a tMySQLInput to tFileOutputDelimited to tFileCompare.
I am using the tFileCompare to check the file produced against the one produced yesterday. I then only want to send an email if the file is different.
So i used an IF trigger to a tsendmail. But i can't get the IF to work.
I'm not very good at Java, so i tried using the (Boolean)globalMap.get("tFileCompare_1_DIFFERENCE") parameter - but i couldn't get it to send anything.
Can anyone help?
Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi
Maybe it sounds wierd but the ((Boolean)globalMap.get("tFileCompare_1_DIFFERENCE")) returns:
- true - if files are the same
- false - if file are different
at least in ver.5.4.1. So use 
!((Boolean)globalMap.get("tFileCompare_1_DIFFERENCE"))

in your IF link, if you want to send mail when files are different

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi
Maybe it sounds wierd but the ((Boolean)globalMap.get("tFileCompare_1_DIFFERENCE")) returns:
- true - if files are the same
- false - if file are different
at least in ver.5.4.1. So use 
!((Boolean)globalMap.get("tFileCompare_1_DIFFERENCE"))

in your IF link, if you want to send mail when files are different
Anonymous
Not applicable
Author

@ xto
Many thanks - worked a charm 🙂