I have cases where the value to lookup in a reference table does not exist and the map just doesn't process the whole record.
EMP_REC:
EMPLOYEE EMP_CODE
100 A
200 B
300 C
EMP_CODE_REC:
EMP_CODE DEPT
A DEPT 1
B DEPT 2
LOOKUP...
Searched the documentation and this forum but couldn't find what format should a text file be in so I can import and create a type tree with it?
I'd imagine it will be something like field name, type, etc.
Thanks in advance!
Hi! I'm a new Mercator user and I'm using a comma-delimited file with quotation marks for each field in the input file:
"ALFKI","Alfreds Futterkiste","Maria Anders"
But when I get the field values, the quotation marks become part of the output field. I need to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.