List Box tool error in macro input

Hi I have a macro that works on the sort and sample tools.

First it lets a user pick a field or two to sort on and then samples the highest and lowest values and outputs them in two macro output

When I connect a file to the macro it

says it cant find the template fields in the macro. I am attaching the workflow

whylistboxisnotworking.yxzp

workflow.png

Interface Tools

Accepted answers

All comments

Raj

@mithily
please add sample input data as it is missing here.

Raj

@mithily
find the workflow attached

mark done if solved.

whylistboxisnotworking.yxzp

mithily

Raj, thanks for your solution but the input files wont have fields named Field1 and Field2 those are only in the template file, I need the macro data to be replaced by the incoming file no matter what the fields are called in the input

mithily

data here

Sample - Superstore.xls

apathetichell

Are you editing the xml of your sort tool to adjust if you have one or two fields coming in and dynamically create it in xml? If the answer to that question is no - then your workflow is wrong.

You are hoping to dynamically change the number of tools flagged in the sort tool - this an xml change. you can change the field name pretty easily via action tool to sort tool - or dynamic rename - but the next part - the selection of one/two/three sort fields and how they are nested- that's the pain. you need to edit the xml of the sort tool (and know how to parse what's feeding from action tool to multi lines if needed). I'd recommend researching that here on this forum - because it's complicated and if done wrong it will break your workflow.

apathetichell

And I'd also recommend having a strategy to convert your files from .xls to .xlsx - or read them in via python or something - .xls is a legacy format which will not be supported at some point soonish.

mithily

Thanks apathetichell the xls is just a sample file from the internet - I will change it to xlsx and also look into the xml - do you have any examples which modify the xml?

apathetichell

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Update-action-tool-using-Raw-XML-option/td-p/1136232

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703