Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Export Column mapping between resources

richzac
6 - Meteoroid

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

14 REPLIES 14
Luke_C
17 - Castor
17 - Castor

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

apathetichell
19 - Altair

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
6 - Meteoroid

@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
17 - Castor
17 - Castor

@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_0-1634303487655.png

 

richzac
6 - Meteoroid

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

Labels
Top Solution Authors