one of the Excel file(xlsx) uploaded shows null but when last empty row is deleted works .How to handle this in data load editor
Hello everyone,
I am using the loop to upload the excel files. But one of the excel files data shows null in the Qlik sense pivot.when I check the data in the file all seems good and when deleting the last row & uploading this shows up in the pivot correctly.I have tried some of the codes with Null and trim which were shared in the forum but it is not supporting.