Change to "null" (string) in a big matrix

oasis2000 — Fri, 01 Mar 2024 12:51:45 GMT

Hi,

I have a .tab file which contains a "table" with +700 columns and 3M rows, more or less. I want to replace all the blanks in the different "cells" with the word "null"

Is there a way to loop throught the rows and / or columns and do some tjava program or something like that so I don't have to do it manually on a tmap?

Thanx

Re: Change to "null" (string) in a big matrix

msjian — Fri, 15 Mar 2024 02:34:03 GMT

hello

you can design a job as follows:

for example:
my input data format as follows: the field separate is “;”
1;Mr;msjian;;a
2;Mr;msjian;;b

but in the job, the tFileInputDelimited and tFileInputDelimited components, set its field separate to "#", that means will make all the line data as one column, then set tJavaRow components code as above to do a replacement, the output file may is your want as follows:
1;Mr;msjian;null;a
2;Mr;msjian;null;b

the sample job see attachment file

Thanks
Jian

topic Change to "null" (string) in a big matrix in Data Quality

Change to "null" (string) in a big matrix

Re: Change to "null" (string) in a big matrix