CODEWITHSUNDEEP
mappinginformaticafield-names
QYT
QYT

Reputation: 9

Handle field with same names but different table in Mapping

I have the following SQL:

select zcactcls.name "ACCOUNT_CLASS",
zcpatcls.name "PATIENT_CLASS",
zcsvc.name "SERVICE"

The name field is used multiple times by different tables.  In the joiner, the fields are noted as name, name1, name2.  It is hard to figure out which of these name fields belong to which table.  How can I alias these name fields to be "Account_Class", "Patient_Class", and "Service" within the mapping. 

Multiple Name Fields

Upvotes: 0

Views: 179

Answers (2)

yoga
yoga

Reputation: 860

Rename the fields in your SQ to match the field names in your SQL.

Upvotes: 0

Maciejg
Maciejg

Reputation: 3353

Just rename the ports - right after the Source Qualifier. Or if you use SQL Override, simply use SQL aliases and name the ports properly right in the Source Qualifier.

Upvotes: 0

Related Questions