List box with Transpose

I'm trying to have an app where you choose the key fields and fields data in Transpose by List Box where it feeds in from an excel sheet! The key field worked as I've chosen only one column but the fields data is not working. In the debug mode, the value is changing but this is not reflected in the output of the transpose.

I believe I need to update the action tool with formula to be able to benefit from more than one input but I can't find out how that specific formula should look like!?

Thank you.

Input

Output

Interface Tools

Accepted answers

patrick_digan

@jad0575 What version are you running? I've attached a yxzp version 10.0 in case that helps. The dropdown tool that you want to update the data section of the transpose should use the generate custom list option with this text in each box:

start text:
<Field field="

separator:
" selected="True" /><Field field="

end text:
/><Field field="*Unknown" selected="False" />

Then you would use an action tool like so:

Annotation 2020-01-20 082546.jpg

Community 2020-01-17.yxzp

All comments

afv2688

Hello @jad0575 ,

The values wont change for that. I would recommend you to run previously another short app and chain it to the actual one just to create a file with the names of the inputs. Then on the listbox use the configuration to read from a file (the one created).

This would do it 🙂

Regards

patrick_digan

@jad0575 Attached is an example. The key is to put some complicated xml in the generate custom list section of the list box tool. Then you can use the action tool to update the xml of the transpose. I'm really just replicating the xml from the transpose tool. I've made it so both the key and data should be able to have multiple fields. @afv2688 was pointing out that when your excel file changes, the list box tool won't necessarily dynamically update itself.

Community 2020-01-17.yxzp

jad0575

Hi Patrick,

@patrick_digan I couldn't open the attached because I don't have the most recent version and it takes ages to get approval to update. would you please post a photo of the XML formula of the transpose to tick the Data Fields?

Many thanks in advance

patrick_digan

start text:
<Field field="

separator:
" selected="True" /><Field field="

end text:
/><Field field="*Unknown" selected="False" />

Then you would use an action tool like so:

Annotation 2020-01-20 082546.jpg

Community 2020-01-17.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703