We have a Excel File (Number 1) with 9 columns. One of the columns is the ID
Need to generate a Excel file (number 2) with 4 columns. 3 of them are contained in the file number 1
To generate the missing column, need to:
- Create a catalog with a field called "PTN"
- Create a form where user will choose one of the PTN options.
- User will input several ID numbers. Script will look for the ID in the File number 1, and will create a excel row with ID, PTN and 2 other columns that match ID row.
If you are spanish speaker is a must, but it is not required.
Please write PM to send you excel samples and start this project.