https://community.qlik.com/t5/Qlik-Automate/Automation-loses-data-when-useing-get-the-Straight-table-data/m-p/2515436#M5798 <P>Hi,&nbsp;<BR />I spoted that my excel writer contain less values than the orignal strighdata table, (less rows, sums of measure fields are not equal)&nbsp;<BR />Automation is made of loop based on numerical (month-year) value that divides the full table,<BR />did somebody had simmilar issue?</P> <P>&nbsp;</P> Wed, 23 Apr 2025 11:24:04 GMT Szymon4605 2025-04-23T11:24:04Z https://community.qlik.com/t5/Qlik-Automate/Automation-loses-data-when-useing-get-the-Straight-table-data/m-p/2515436#M5798 <P>Hi,&nbsp;<BR />I spoted that my excel writer contain less values than the orignal strighdata table, (less rows, sums of measure fields are not equal)&nbsp;<BR />Automation is made of loop based on numerical (month-year) value that divides the full table,<BR />did somebody had simmilar issue?</P> <P>&nbsp;</P> Wed, 23 Apr 2025 11:24:04 GMT https://community.qlik.com/t5/Qlik-Automate/Automation-loses-data-when-useing-get-the-Straight-table-data/m-p/2515436#M5798 Szymon4605 2025-04-23T11:24:04Z https://community.qlik.com/t5/Qlik-Automate/Automation-loses-data-when-useing-get-the-Straight-table-data/m-p/2515451#M5800 <P>Problem solved,<BR />I found that there was a random breake lines in my data.&nbsp; That used to couse an appearing of ' " ' sign at the begining of string, i found it, after copy and paste missing values from reference source. I couldn't find that issue by the "normal" data checking.<BR />I've solved it by adding clearing statement into my load script&nbsp;</P> <P>&nbsp;<STRONG><EM>replace(replace(FIELD, chr(10), ''), chr(9), '') as FIELD</EM></STRONG></P> Wed, 23 Apr 2025 13:10:37 GMT https://community.qlik.com/t5/Qlik-Automate/Automation-loses-data-when-useing-get-the-Straight-table-data/m-p/2515451#M5800 Szymon4605 2025-04-23T13:10:37Z