Urgent help required

[rita1994]

I am new to Alteryx , I am a fresher I need urgent help in creating an alteryx workflow.

Alteryx create macro to handle duplicate row, Aggregate data based on a specified key field(s)(dynamic input).

I see this community is very active could anyone help me in creating this ?

[CoG]

Do you have sample input and output (preferred not as image)? I am unsure why you would need a macro to do this. In addition, there are many ways to handle the problem based on what you mentioned.

For example: Unique Tool will remove duplicate rows based on selected fields, and since you plan to aggregate data then you can use the Summarize Tool. Some extra details would be beneficial in narrowing down exactly what you need help with.

[rita1994]

Hi Andrew,

I have been given task from my supervisor, even I asked him the same question but he told to do with macro.

he told any dynamic input can be given

Its okay if you have nothing to suggest.
I appreciate your response.

[rita1994]

Name |Age 2 columns it will accept dynamic values there will be one more dynamic input which will take age as input after entering Age , it will add up all the age column

[CoG]

What you mean by dynamic needs to be clarified too. There is a Dynamic Input Tool that allows you to pull in data from multiple file paths or via SQL Query Modification. What it sounds like you are referring to is a workflow (or macro if that is the expected deliverable) that has no standardized input. For example you could run this macro with

Name	Age
John	35
Jane	29

and you also need to be able to run with:

Product	Color	Quantity
Chair	Purple	5
Table	Black	1

Is that correct? How do you know what columns to aggregate on, and what aggregation method to use? Is that dynamic or do you want to sum all numeric fields every time? This is critical information to build a macro since the whole point of a macro is standardize a repeatable/reusable process. There's no simple way to create a truly dynamic macro that will take in any kind of data and allow you to aggregate however you want. It doesn't even really make sense to do so, since you're only using 2 Tools. Finding the structure, is going to be the key to this problem. A macro can be built, but you need to know exactly what it needs to be able to do to build the appropriate interface.