Export Column mapping between resources

[richzac]

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).

[Luke_C]

Hi @richzac , some sample data might be helpful, both starting data and desired output based on the data.

[apathetichell]

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.

[richzac]

@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.

[Luke_C]

@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.)

[richzac]

@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!