File Parser: Ethnic Group always comes up blank
I'm working on a new File Parser setup with 6 rows of SCC_STG_DIV_ETH. The first and last values come direct from the file, while the others are calculated by parsing and translating a field delimited by ", ". The problem is that the load insists the ethnic group code in SCC_STG_DIV_ETH rows 2-5 is always blank. The calculations work when used for other fields, but for SCC_STG_DIV_ETH.ETHNIC_GRP_CD, they come up blank. SCC_STG_DIV_ETH.ETHNIC_GRP_CD even came up blank when I got rid of the calculation and just hardcoded a value.