We are loading application with two tables Table A & Table B. if Table A missing, the application will pop up an error like "cannot open file" but this should not happen. Application should ignore this error and continue it's execution
I am using below code to avoid this error but it's not working
set ErrorMode = 0; Query_Target: LOAD Consignment_No, Track_No, Packet_Id, Barcode_Status, Destination, Shipment FROM [lib://AttachedFiles/Query Target.xlsx] (ooxml, embedded labels, table is Sheet1);
set ErrorMode = 1;
Query_Status: LOAD statuscode, description, resolution FROM [lib://AttachedFiles/Query Status.xlsx] (ooxml, embedded labels, table is Sheet1);
Currently Query Target Table is not available but application should not through an error I am using Set ErrorMode but it's not working below error is coming
is there any alternate way to achieve my requirement. Could some one help me on this
Hello @SatyaPaleti, the filesize() function returns an integer containing the size in bytes of the file filename or, if no filename is specified, of the table file currently being read. You are getting null probably because the argument you are passing to the function is not a file name. Maybe this thread could help you.
If the issue is solved please mark the answer with Accept as Solution.