This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a complex workflow with many different macros that are then unioned together for output. The problem is that there is not always data for every macro, and when this occurs it creates an error because I use a dynamic rename for the headers in the macro.Therefore the default headers of "1", "2", etc. are not recognised fields.
Error: MCRO_Get labels (894): Tool #14: The field "1" is not contained in the record. Error: MCRO_Get labels (894): Tool #107: The field "2" is not contained in the record. Error: MCRO_Get labels (894): Tool #109: Parse Error at char(13): Unknown variable "2" (Expression #1) Error: MCRO_Get labels (894): Tool #165: The field "1" is not contained in the record.
It is possible to add a formula/macro to ensure that the key fields are added even where no data is present but I have a lot of macros and this seems tedious and time-consuming.
Is there a quick way to avoid errors for unknown fields caused by no data passing through?
The big issue is that the error prevents the rest of the data passing through the workflow due to it being linked to the union downstream.