Automation loses data when useing get the Straight table data and Excel writer.
Hi, I spoted that my excel writer contain less values than the orignal strighdata table, (less rows, sums of measure fields are not equal) Automation is made of loop based on numerical (month-year) value that divides the full table, did somebody had simmilar issue?
Problem solved, I found that there was a random breake lines in my data. 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. I've solved it by adding clearing statement into my load script
replace(replace(FIELD, chr(10), ''), chr(9), '') as FIELD
Problem solved, I found that there was a random breake lines in my data. 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. I've solved it by adding clearing statement into my load script
replace(replace(FIELD, chr(10), ''), chr(9), '') as FIELD
