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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
EvoticTalend
Contributor
Contributor

How control null values before tmap?

I have a file with a null in an especific row.

 

I have the error:

Exception in component tJavaFlex_1 (Project)

java.lang.StringIndexOutOfBoundsException: begin 0, end -1, length 0

 

The row is that. Null in the fifth value.

0695b00000JN7sCAAT.png 

My flow (the row 312 is the null)

0695b00000JN7sWAAT.png 

How can i control that?

Labels (3)
2 Replies
tnewbie
Creator II
Creator II

You can default a value to this column/field in your tFileInput to a value that is easily identifiable and then handle it as you move along

gjeremy1617088143

Hi @Ivan R​ , you can use tFilterRow component and set in advanced condition the control of the null value.

Send me love and kudos