AMP Engine - Getting error in parsing the data in column or rows.

ShivaniRohilla1

Hello Team,

I am parsing the data in a workflow with AMP engine where I am using a macro which splits the data either in rows or columns. Here, I am getting an error which is attached below.

I know that we can simply use the Text to column tool to parse the data in the workflow which will work fine with both normal and AMP engine, but the same tool is not working if I am using in the macro using AMP engine (in case I use normal engine, it's working fine), which i want to know that why Text to column is working in the macro in case i am running it using AMP engine.

I am attaching the workflow and the macro. Please run the same using AMP engine and let me know if there is any issue in the macro or the macro can't run using AMP engine with a reason.

Thank you!

Error Message.PNG

Parsing Data into Columns or rows.yxmc

Testing Workflow.yxmd

Sebastiaandb

@ShivaniRohilla1 He i looked at your workflow and macro!

I think the problem is this, both (workflow and macro) have to be either "normal" or "AMP". I do get the same error if i set the macro to "normal" and keep the workflow in AMP mode. If won't get the error if both are in the same setup (AMP or normal mode).

Greetings seb,