Designer Input a row of data from a workflow into an interative macro

Question

Trying to find a solution in Designer to configure my macro to receive data from a workflow.  The data in the workflow reads from a data source.  There is so much information but I have not found a solution that explicit states how to configure a macro to receive input from a workflow.  If you know a completed solution, please share the link

Thanks

New Alteryx Developer

LW-doa1408 · Answer

Thank you for your responses, I'm still not able to accomplish my goal.  I did look @ Challenge #12; however, I have questions .  Yes, I created the macro.  So here's what I'm trying do accomplish.  I have a flat file with a data elements where 1 column has a very long text with multiple newlines. See notepad - unfortunately, I do not have other development tools that will help format or even make life easier to code.  Here are some things I've tried

1. Created an iterative macro that concatenates the lines - the problem is it concatenates all lines in file

2. As I understand there's no concept of a global variables

I dare not insult with my simplistic workflow; therefore, I provide a snapshot of the workflow

Please see attachment

Input Text String Sample.txt

Sample.png

JosephSerpis · Answer

Hi @LW-doa1408 a Macro Input is all that is needed to take data from your workflow into the macro. There are number of resources such as Interactive lessons from Academy section of the community. If you like to look an existing example may I suggest weekly challenges. Challenge 12 uses a Iterative Macro and has a solution you can download and explore to help you understand how Macros work.

OTrieger · Answer

@LW-doa1408

Have you created a macro in the past?

If not do the interactive lesson to get a good grasp on what is needed. If you want data to get into a macro you will need to use Macro Input tool.

I do not understand your request to get a complete solution developed by someone else. Get the knowledge get do it yourself. If you will fail to get it done then ask for help, I'm sure that there are plenty of guys here that will be willing to help.