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
The field info tool might be a good start for this. I also recommend getting in the habit of updating the description in the select tool with some more detailed notes. I've been getting into the practice of providing the output data and including a tab that is a simplified view of the field info tool so the end users can review each field's source and any assumptions used.
Thanks for the response. When I drag the Field Info Tool and link it to the import tool I get a message "This tool has no configuration". How do I configure?
Hi @richzac ,
Could you give us an example of what you have and what you're trying to do so we can understand you better?
Why would you need a map of fields in the workflow in Excel?
M.
So you have the select tool to map the input columns to the target table. It looks like a grid with the field name, the type, the size, and the rename values. I want to export the grid to a spreadsheet. As a second step to the migration process we have, is to present a map of the source and target columns with notes, examples, etc. to our clients If we could export the actual select tool grid contents to a spreadsheet it would make our lives easier. Some of out selects have hundreds of columns.
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!
