Originally posted by: SATH66
when we have input file without any "CO" and " 18 "
NE01 12A339257201 201.10 2012101711000553
NE01 12A339257201 CO 18 548.95 2012101711000553
NE01 12A339257201 301.10 2012101711000553
we need to populate output as
CAS* * *201.1~
CAS* * *301.1~
So i used an functional map with extract function as extract claims which
F_FUN_CAS_EMPTY_TEST(EXTRACT(Disallow_ClaimLevel Record:IN_DISALLOWSETCLAIM_RECORD,PROV_ADJ_CODE Char Field:Disallow_ClaimLevel Record:IN_DISALLOWSETCLAIM_RECORD=" "&TRIMRIGHT(HIPAA_ADJ_CODE Char Field:Disallow_ClaimLevel Record:IN_DISALLOWSETCLAIM_RECORD)=" ") ) )
BUT I AM GETTING ONLY ONE SEGMENT IN OUTPUT
CAS* * *201.1~. CAN ANY ONE PLEASE ADVISE
#IBM-Websphere-Transformation-Extender#IBMSterlingTransformationExtender#DataExchange