Alteryx App building

I have created a workflow which aims at splitting the data with two fields as the splitting basis.

In order to better enhance the user's experience and greater flexibility, I am building an Alteryx app for the workflow, which allows the users to determine the two fields as splitting basis for their own data sources. Yet, it is not working.

Much appreciated if you could provide some advices.

Cheers,
Jason

New Workflow_wip.yxwz

Workflow

Apps

Accepted answers

grazitti_sapna

You need to use the formula tool to update the location as it wont create a new file but sheet. Please use the below configuration. Sending you workflow

New Workflow_wip.yxmd

All comments

gabrielvilella

Hi @Jwwwson, it's challenging to understand what you are trying to achieve without the data. Can you provide a sample file? What I changed on your app is just adding the dropdowns connected to the file input, this way the name of the fields will automatically populate the dropdown. What is exactly that is not working?

New Workflow_wip_2.yxwz

grazitti_sapna

Hi @Jwwwson , The workflow does not seem to have errors. But if you can share a sample file on which you are performing this workflow and the parameters you are passing to this App can help to determine your problem.

Jwwwson

@grazitti_sapna @gabrielvilella

Thanks for your help in advance.

As in the workflow, the predetermined field for the splitting is "1st person" and "2nd person", yet if the users input the file attached, and would like to set the fields "First contact" and "Second contact" as the splitting basis in app, and errors occurred.

Cheers,
Jason

Input_test.xlsx

grazitti_sapna

@Jwwwson , This is because the unique tool is not configured to update the fields. Please use the below configuration for unique tool as well to update the fields based on selection.

Jwwwson

@grazitti_sapna, many thanks! I have updated the workflow as advised, and that part is solved. However, the location of the output cannot be updated as chosen in the app. The output files are saved in the original location as stated in the workflow instead. Kindly advise. Thanks!

Thanks & regards
Jason

grazitti_sapna

You need to use the formula tool to update the location as it wont create a new file but sheet. Please use the below configuration. Sending you workflow

New Workflow_wip.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703