Select columns dynamically at the run time in Analytical App

[AmitBelagali]

Hi,

I am bulding an analytical application. I have a scenario wherein, user must select the columns at run time and post which those coulmns must be grouped by. Please help me on this.

[DataBlender]

Hi @AmitBelagali,

From your query I think what you need is to check the option 'Show field map' in the macro input tool:

Show Field Map: When checked, the end user will be asked to point to their fields that match the template input specified in step 1.

[jgo]

@AmitBelagali,

Are you referring to needing to modify an SQL Select query based on what the user selects?

We (or me specifically) would need a bit more details and maybe show/share what you've developed in Alteryx so far to add some context to what you'd like Alteryx to do.

If it might help, take a look at the Virtual Training site. There's 3 "Applications" and 3 "Macros" recordings that might include what you're trying to achieve.

[AmitBelagali]

Hi @DataBlender,

Thanks a lot for your swift reply.

I cannot use Macro Input tool as the workflow will be converted to a macro type workflow and not Analytical app. I need to have the workflow as an analytical app.

The problem that I am facing is, I have source as an excel, there are like 24-26 columns. In which, I need to give option to user to select dimensions and measures. Post which, if the field is a string then it should be added to group by and if the field is a measure ( double or float) then it should be summed. 

Hope this is clear. 

Thanks in advance. 

[AmitBelagali]

Hi @jgo,

I am not refering to modify the SQL but excel. 

So far I have developed an analytical app, wherein the user has the  ability to select the source of his choice. Then I have given a 2 radio buttons which will enable the dropdown box depending on the radio button selected. I am using a detour component to manage the flow. Now, what issue I have is, I need to give option to user to select dimensions and measures. Post which, if the field is a string then it should be added to group-by and if the field is a measure (double or float) then it should be summed. 

Hope this is clear. Kindly share your views on it. 

[jgo · Accepted solution]

Hi @AmitBelagali,

Attached is probably the easiest way that I can think of, assuming I understood your need correctly, by transposing and then crosstabbing the data back, but SUM'd. The action tools are used to simply update the field selections.

I know that there's another way to accomplish this by having the Action tool update the XML configuration of the Summarize tool directly, but updating XML is a bit out of my skill set.

Hope this helps.

Best,

Jimmy

[AmitBelagali]

Hi jgo,

This was exactly I wanted. This is great. Fantastic. But now my only worry is, I need to use the selected dimension and measure in group by and sum. If you could find that, then it would be great.

Thanks a lot once again.

Thanks,

Amit Belagali

[jgo]

Hi @AmitBelagali,

Thank you for accepting my response as your solution. I'm not sure if i'm following what you mentioned though. Would you be able to share a workflow that encompasses what you're trying to do? This would give me a bit more perspective if I can a look at what the data looks like to start with and what it should look like afterwards.

[AmitBelagali]

Hi jgo,

I will not be able to share the workflow as it has too many components involved in it and more over, there is client sensitive data. Sorry about that.

The problem that I am facing is, once the user selects the required dimensions and measures, all the measures selected should be added to summarize component where, it should be summed and like wise, dimensions also should be added to summarize tool where they should be added as groupby.

Hope I am clear.

Thanks,

Amit Belagali

[HBarge]

Hi Amit,

Thank you for the example.

However, I am unable to get an output.

Can you make this a bit more easy? 

Output