Urgent help required

Question

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 · Answer

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

NameAgeJohn35Jane29

and you also need to be able to run with:

ProductColorQuantityChairPurple5TableBlack1

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.

rita1994 · Answer

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

rita1994 · Answer

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.