I've got everything set up properly to transfer data from HL7 flat file to SQL, but now the variable I created in the transformer comes over into sql as just the variable name.
In the transformer the Variable is called l_name and is mapped to msg['PID']['PID.5']['XPN.1'].toString() I've tried adding it to global map and the rest, and they all still return {$l_name} to my sql table.
here is the sql statement
INSERT IGNORE INTO testhl7 (l_name, f_name) VALUES (${l_name}, ${f_name});
the variables show up in Destination Mappings and I drug them over.
Any suggestions?
Thanks,
Jeff
In the transformer the Variable is called l_name and is mapped to msg['PID']['PID.5']['XPN.1'].toString() I've tried adding it to global map and the rest, and they all still return {$l_name} to my sql table.
here is the sql statement
INSERT IGNORE INTO testhl7 (l_name, f_name) VALUES (${l_name}, ${f_name});
the variables show up in Destination Mappings and I drug them over.
Any suggestions?
Thanks,
Jeff
Comment