Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have simple job setup to read a file, pass it through tHMap and send to tLogrow. I'm getting mixed results of null values with data values when I should be getting all real values. Here's the details:
I'm reading an EDI x12 278 file (contents copied in at the bottom). I have other tHMaps pulling out specific data that I want, but this one in particular is pulling from a section that loops. The elements that I want to pull from the section that loops are coming back in two separate rows, which is great. But the accompanying data identifying which transaction they belong to is null. Hare some screen shots:
My job:
My tHMap:
The Code_Type and Procedure_Code elements are repeating in the file I'm reading. When I do a Test Run, all data elements are returned / read.
The Code_Type and Procedure_Code are outlined below.
However, when I run my job, the Code_Type and Procedure_Code are returned as two rows, which is what I want, but the first several elements are null:
Below is a copy of my sample EDI file. Any ideas would be appreciated!
ISA*00* *00* *ZZ*123456789012345*ZZ*123456789012346*080503*1705*>*00501*000010216*0*T*:~
GS*HI*1234567890*1234567890*20080503*1705*20213*X*005010X217~
ST*278*0001*005010X217~
BHT*0007*13*YZZ347*20050502*1101~
HL*1**20*1~
NM1*X3*2*CAPITAL INSURANCE COMPANY*****46*789312~
HL*2*1*21*1~
NM1*FA*2*GENERAL HOSPITAL*****46*8189991234~
HL*3*2*22*1~
NM1*IL*1*SMITH*MARY****MI*12345678901~
HL*4*3*EV*1~
UM*HS*I**12:B*****Y~
HI*BF:1831*BF:2630~
HSD*VS*3*WK**34*2~
CR6*1*20050502*RD8*20050502-20050801***W*I~
NM1*SJ*2*CARING HANDS HOME HEALTH AGENCY*****24*345678912~
HL*5*4*SS*0~
SV1*HC:G0154~
HL*6*4*SS*0~
SV1*HC:B4184~
SE*20*0001~
GE*1*20213~
IEA*1*000010216~
Hello,
Could you please clarify on which talend build version you got this issue?
Best regards
Sabrina