I have a workflow that contains multiple control containers that write into different sheets of the same workbook. Currently the output file is stored in SharePoint and analytic app works fine (though i have had write errors like number 3 in the past).
When I change the file path of both input and output files to a network drive and run the app, I get thrown different errors.
Note: I use action tools to update the file path and file names
1. Formula (142): Parse Error at char(43): Unknown variable "Reference" (Expression #1)
this is the formula
IF CONTAINS([Text], "NONREF") OR CONTAINS([Reference], "BOACHGEUSD") THEN [Amount in doc. curr.] ELSE 0 ENDIF
2. Output Data (344): Unable to create backup of \\xxx\Alteryx Output files\5300 AAI MXN FY 2024 Alteryx.xlsx to \\xxx\Alteryx Output files\5300 AAI MXN FY 2024 Alteryx.xlsx.bak: The process cannot access the file because it is being used by another process. (32)
3. Output Data (68): Can't open file: \\xxx\Alteryx Output files\5306 AAI MXN FY 2024 Alteryx.xlsx: The process cannot access the file because it is being used by another process. (32)
4. Dynamic Input (138): The file "\\xxx\5300_GL SAP Report_Feb_2024.XLSX" has a different number of fields than the 1st file in the set and will be skipped
Any help with this will be appreciated.
P.S: For error 3, I suspect its because I am writing into the same file from multiple containers. I introduced control containers to enforce some sort of sequencing such that one completes before the other starts but it doesn't seem to have resolved the issue.
Is there a way to implement workflow checking if the output file is ready before writing into it?
I have attached a subset of my flow.
