I have a list of criteria in a database table that are entered by user. This criteria is in a format X > 5 for Segment A, X > 7 for segment B, and so on.
The data is collected using OLE DB Source where I specified a stored procedure to retrieve data. The record set has three columns: IdNumber, SegmentId and Total.
My conditional split should look like this:
SegmentId == 1 && Total > 5 (I would like to replace X with the actual value stored in Total column. SegmentId == 1 && !(Total > 5) ... and so on.
So my question is, how can I use a condition which is string-based and stored in database in the Conditional Split Transformation Editor?
Regards,
Huske
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)