Help with wrong output connected to Excel

[Henrieta]

Hello everyone, 

I've recently encountered a recurring issue in one of my Alteryx workflows. The workflow is built to apply logic to my dataset and then select a sample for further testing. The sample selection is driven by user-defined criteria set through Interface tools. In this example, the user can specify the number of samples both with and without approval:

When I run the workflow, the results window at the final output step correctly reflects the selected samples (right number of samples, right logic, all of the fields).

However, when I open my output file Excel sheet, there are only two samples selected through the workflow:

This problem has occurred across multiple workflows involving sample selection. It seems that one of the Interface tool selections is not being carried over to the Excel output, even though it appears correctly in the final Alteryx output step.

Has anyone experienced something similar? I’d greatly appreciate any advice or suggestions you might have.

Thank you!

[Pilsner]

Hello @Henrieta 

This does sound like an awkward problem, so I'm not 100% sure how to fix this; nonetheless, I've outlined my thoughts below.

From the second screenshot you have provided, I can see that you are trying to preserve the document formatting in your output. (I'm also guessing option 3 reads "Overwrite Sheet or Range")

As the option suggests, this means you have to define a range of cells to overwrite. If the range is not large enough (does not include enough rows) then your sample size will be restricted. If this is the issue, the fix should be able to increase the number of rows available in the range you have defined in the output tool. 

Please let me know if this is of any help.

Regards - Pilsner

[Henrieta]

Thank for your input. Yes i do have the preserved formatting and the option "Overwrite sheet or range" selected. Even with the range i do have enough cells defined. So i do not know what could be the issue. Do please you have any other suggestions or ideas?

[Pilsner]

Hello @Henrieta 

Thanks for checking the cell ranges, sorry to hear that hasn't led to a solution. 

My only other thought would be to make sure the Excel sheet itself has no formatting rules on the columns/cells you are trying to overwrite. 

Failing that, I appreciate it often seems futile, but deleting the tool and reconfiguring is always worth trying. I have tried to recreate the issue on my end, but could not replicate the same error. If you are able to share the workflow with some dummy data, that would help.

Regards - Pilsner

[binuacs]

@Henrieta Run your workflow in debug mode , manually feed the arguments then you will see what is exactly writing in the output tool

[Henrieta]

Thanks  for the response I already tried this approach and nothing seems to help the issue.

[caltang · Accepted solution]

Is your action tool configured correctly? Sometimes old changes are not carried over. Can we have screenshots of the config?

[Henrieta]

Thank you for you help, i went through the WF once again and my action tool was not configured properly. it is now working smoothly.