Let user map columns via app

[Inactive User]

Hi everyone,

I realise this question has been asked before, and I've tried several solutions from here, but somehow I can't get them to work for me. My only wish is to be able to let the user map the columns of their data coming in to our data model so we can then dynamically analyse everything correctly, even if the columns originally had different names.

So user workflow:

• User selects file
• User tells Alteryx which column is for date
• User tells Alteryx which column has "Profit"

This is sort of what my workflow looks like right now:

I attached the example; ideally I would have 5 options for 5 columns that need to be mapped/renamed.

I'd be super grateful for any help!

Cheers,

M

[mceleavey]

@Inactive User ,

yes, that's correct. You can easily just add a RecordID field and group by that. That would fix the problem.

I've attached the latest version. This will always use a generated ID field for the transpose and crosstab.

M.