For those of you who are trying to remember how to do IF/IIF functionality in the SSIS Derived Column control:
({comparison} ? {truepart} : {falsepart})So, if I want to evaluate the similarity from a fuzzy lookup, it would look like this:
(_Similarity > .78 ? ID : "")
Maybe someday Microsoft will standardize all of the expression languages in their BI tools!
peace
4 comments:
Thanks, I'm always forgetting this too, and often have to come back here to get reminded.
Thanks for the feedback... it's good to know people read this!
Bob
Thanks for the info!
thanks
Post a Comment