Can we include conditional statements in the importmappings screen? If yes, how?

Can we include conditional statements in the importmappings screen? If yes, how?

book

Article ID: KB0090786

calendar_today

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(`)

Issue/Introduction

Can we include conditional statements in the importmappings screen? If yes, how?
Powered by Wolken Software