Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Papademuchos
Creator
Creator

Data Mapper tHMap returning null values

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:

0693p000009HdBZAA0.png

My tHMap:

0693p000009HdCIAA0.png

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.

0693p000009HdE4AAK.png

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:

0693p000009HdFWAA0.png

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~

Labels (2)
1 Reply
Anonymous
Not applicable

Hello,

Could you please clarify on which talend build version you got this issue?

Best regards

Sabrina