Hi,
I need to retrieve all column headers so I can use these for dynamically selecting them in the next chained app.
Currently I'm using a lot of tools for this and I have the feeling I'm making it more complex than necessary.
How could I simplify this?
Hi @leonhekkert
You could use a select tool and then click "Metadata" on the results pane rather than "Data" - not sure what your next stage is but the metadata output can be fed into a list-box, drop-down etc
If this works for you - please do hit "Accept as solution"
@leonhekkert not sure if this is suitable for your requirement. However, if so it'll trim a couple of tools off:
- Transpose as you have
- Make Value = Name
- Output this list with NAME & VALUE fields
- Reference this in your list box configuration by selecting the 'External Source' method under List Values (can use a relative path)
If not, I tend to use your method when I have the same requirement (though without the sort/select as my order never seems to be precious), so I'm curious to see if there are better and more efficient ways!
@DataNath
I did the transpose and then the formula tools (value = name) as you suggested. But then there are a lot of duplicates that I need to eliminate.
So used an unique tool but unfortunately this one also automatically sorts alphabetically so then I would still need the record, sort and select tools. :|
I already use the reference method that you mentioned. :)