How can I default CIM-only attributes based upon input values at import time? In other words is it possible to have conditional statements in the import mappings while importing data?
Article ID: KB0090808
Updated On:
| Products | Versions |
|---|---|
| TIBCO Collaborative Information Manager | - |
| Not Applicable | - |
Description
Resolution:
Yes that is possible.
You can have the conditional sql statements in the map field just like the hardcoded values as follows:
CASE WHEN ((@<DatasourceName>.<attributeName>) = 'Y') THEN (SUBSTR('true',1,4)) ELSE (SUBSTR(‘false’,1,5)) END.
If this is given for attribute "FLAG" then it will be assigned 'true' if the value of datasource.attributename is 'Y' else it will be assigned 'false'
And it can only take valid sql statements.
Yes that is possible.
You can have the conditional sql statements in the map field just like the hardcoded values as follows:
CASE WHEN ((@<DatasourceName>.<attributeName>) = 'Y') THEN (SUBSTR('true',1,4)) ELSE (SUBSTR(‘false’,1,5)) END.
If this is given for attribute "FLAG" then it will be assigned 'true' if the value of datasource.attributename is 'Y' else it will be assigned 'false'
And it can only take valid sql statements.
Issue/Introduction
How can I default CIM-only attributes based upon input values at import time? In other words is it possible to have conditional statements in the import mappings while importing data?
Feedback
Yes
No
Powered by
