Can we include conditional statements in the importmappings screen? If yes, how?
Article ID: KB0090786
Updated On:
| Products | Versions |
|---|---|
| TIBCO Collaborative Information Manager | - |
| Not Applicable | - |
Description
Resolution:
It is possible to include conditional statements in the import mappings screen, for map attribute.
Any conditional statements have to be valid SQLs.
An example if it is:
CASE WHEN ((@NA_DATA.isTradeItemInfoPrivate) = 'Y') THEN (SUBSTR('true',1,4)) ELSE (SUBSTR('false',1,5)) END
It will import true if datasource attributes value is Y else it will assign false. Make sure you give the single quote(') instead of command quote(`)
It is possible to include conditional statements in the import mappings screen, for map attribute.
Any conditional statements have to be valid SQLs.
An example if it is:
CASE WHEN ((@NA_DATA.isTradeItemInfoPrivate) = 'Y') THEN (SUBSTR('true',1,4)) ELSE (SUBSTR('false',1,5)) END
It will import true if datasource attributes value is Y else it will assign false. Make sure you give the single quote(') instead of command quote(`)
Issue/Introduction
Can we include conditional statements in the importmappings screen? If yes, how?
Feedback
Yes
No
Powered by
