I want to get a spreadsheet that maps all the columns from input and output sources. I imagine it would be a printout of the select workflow step (field to field mapping).
Hi @richzac , some sample data might be helpful, both starting data and desired output based on the data.
you can save join/select tool config info as .yxft files. You can then bring them in as text and parse them to get the required output. I guess. I've never done it - but it should be possible.
@apathetichell I thought about that but the .yxft files do not contain the rename columns (target columns in our database tables). Unless you know a way to also export the rename columns along with the source columns from the spreadsheet to import?
@Luke_C There is no data to export I am trying to export the grid from the Select Tool window. The grid shows the inbound column name, the data type and the outbound rename column.
@richzac My original field info tool suggestion might be your best bet. Use a field info tool before and after the select, then join on record position (assuming you don't reorder fields.)
@Luke_C My colleague figured it out:
Click on the "Select" bubble, then in the output window click on "metadata", Under actions click "Copy to Clipboard" , then open excel and paste that in
Thanks for all of your comments/suggestions!
User | Count |
---|---|
17 | |
15 | |
15 | |
8 | |
5 |