https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266906#M45971 This not working maybe this code is not good?<BR />The main idea is describe in first post how to code this in tmap object?<BR />Thanks in advance<BR />Rafal Wed, 31 Oct 2012 14:28:47 GMT Anonymous 2012-10-31T14:28:47Z https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266902#M45967 Hi <BR />I've csv input file with 256 columns. Every two rows have the same EntryID. I need to replace on field in second row from first row example: <BR />Input <BR />RowNumber EntryID TAXRateId <BR />1 1 3 <BR />2 1 null <BR />3 2 5 <BR />4 2 null <BR />5 3 6 <BR />6 3 null <BR />Output after Talend job should look like below: <BR />Output <BR />RowNumber EntryID TAXRateId <BR />1 1 3 <BR />2 1 3 <BR />3 2 5 <BR />4 2 5 <BR />5 3 6 <BR />6 3 6 <BR /> <BR />Input CSV file have all strings value output also required strings. Input and output file schema have 256 columns. <BR />Any idea how to fast build? Possible only with using tmap? <BR />Thanks in advance for any help <BR />Rafal Sat, 16 Nov 2024 12:09:51 GMT https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266902#M45967 Anonymous 2024-11-16T12:09:51Z https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266903#M45968 hi <BR />have a look at tMemorizeRows. <BR />hope it helps <BR />regards <BR />laurent Fri, 26 Oct 2012 13:44:02 GMT https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266903#M45968 Anonymous 2012-10-26T13:44:02Z https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266904#M45969 kzone Thanks for this info. <BR />I'm trying to use Tmemorizerows and tmap to do this but when I have on tmap this code: <BR />(TAXReclaimCode_tMemorizeRows_1 == null || <BR />!TAXReclaimCode_tMemorizeRows_1 == null.equals(TAXReclaimCode_tMemorizeRows_1)) <BR />? row7.TAXReclaimCode : "" <BR />Talend sending me errors in tmap component. <BR />I'm using string values for this any idea how to fix this. <BR />Kind Regards <BR />Rafal Wed, 31 Oct 2012 13:18:41 GMT https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266904#M45969 Anonymous 2012-10-31T13:18:41Z https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266905#M45970 use isnull and not Talend functions. Wed, 31 Oct 2012 13:22:05 GMT https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266905#M45970 janhess 2012-10-31T13:22:05Z https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266906#M45971 This not working maybe this code is not good?<BR />The main idea is describe in first post how to code this in tmap object?<BR />Thanks in advance<BR />Rafal Wed, 31 Oct 2012 14:28:47 GMT https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266906#M45971 Anonymous 2012-10-31T14:28:47Z https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266907#M45972 I think this can also be done with a tMap. <BR />inputfile.xls <BR /> \ <BR /> tMap --&gt;output <BR /> / <BR />inputfile.xls <BR />make an inner join on entryId <BR />and filter taxRateID on the first input to not null and on the second input to null <BR />then map fields EntryId and TaxRateId from the first input <BR />and map rowNumber from the second input. Wed, 31 Oct 2012 15:07:59 GMT https://community.qlik.com/t5/Talend-Studio/How-to-replace-null-empty-string-values-with-earlier-row-s/m-p/2266907#M45972 Anonymous 2012-10-31T15:07:59Z