on 10-21-201512:18 PM - edited on 07-27-202111:46 PM by APIUserOpsDM
Sometimes you only need to read in specific fields from a database or input. Within Alteryx it is as easy as using a Formula tool, Dynamic Rename and Dynamic input!!
The first step is to bring in the master file and the list of field names you wish to carry through from the Master file.
Next attach a formula tool to the field names list and create a new field with the expression "Keep-" + [FieldNames].
This will rename the fields with “Keep-” appended to the field name.
The next step is to use a dynamic rename tool to “Take Field Names from Right Input Rows”. In the 'New Field Name from Column" select the field which has just been created above.
Use a dynamic select tool to ‘Select via a formula’ and use the expression below to find the field which has ‘Keep-“ appended to the left hand side. This will then only bring through the specific fields from the Master file which you have listed in the field name input.
Using a dynamic rename you can return the fields to their original names through a substring function. This will remove the "Keep-" from the field name.
You now just have the fields you want from the Master input file!