Macro Error

[bilalkhan01]

Ran into an issue with a macro “a field was missing a closing quote in record 70381” does anyone know how to amend this?

Thanks :)

[abacon]

It depends on what the macro is doing. It sounds like you are doing something with csv files but it is hard to tell with the information given.

[OTrieger]

@bilalkhan01 

It seems that you are processing a formatted text file, can be csv, xml or any other delaminated format.

Now in these files the quotes marks are indicating the beginning and ending of text holder, or in other words the text for that specific.

You are getting this error as something is violating this rule, Alteryx is expecting to have "nnnnn","kkkkkkkk","lllllll" etc. but if you have a forbidden character or symbol in the text one or more of these text holders will be broken and then Alteryx cannot find the beginning and end.

Another reason for it can be that you transformed the data and then delete some part of the place holders or added additional ones that violating the structure.

In the error message you should have a number, that should indicate for you where the error is.