Sounds like you have a UDF in the original integrated editor, but not in Jupyter Notebook. I would create a Jupyter Notebook for the UDF. Whether or not you were previously working in Jupyter Notebook, the steps are largely the same, and detailed below:
Preparation: Sort the table where you ran into an unexpected FNF applying your Map UDF, so that the row containing FNF is within the first 100 rows.
- If the UDF was written in a notebook connected to another workbook, you would make a copy of the notebook, carefully replacing the cell containing the Connection code snippet, from the code snippets menu into the top cell of the notebook.
Copy the UDF from the integrated UDF editor by clicking the UDF icon , selecting the module containing your UDF, and copying the Python code for your UDF from the module.
1. Click the Jupyter Notebook icon and create a new notebook.
2. Add the Map UDF snippet from the code snippets menu. Even if you had a Map UDF snippet prior, you should add a new one. A new snippet will allow you to choose new source columns as parameters for your UDF, and automatically create a test function. Note: Do not run the old Map UDF snippet in Jupyter.
3. When prompted for module name, version, and column data, consider versioning the module to limit impacts of these changes across other workbooks using the UDF. Choose the table and columns to replicate the operation you attempted to apply. At this point, XD will add a code snippet which imports the appropriate data, creates an editable function definition, and test code.
4. Paste the UDF code from your module into the section of the code snippet containing the function definition, above the section(s) marked as "do not edit this code".
5. Replace the function definition with yours, making sure the function name and parameter order matches the original UDF code. As you might expect, parameter names don't need to match, as long as their order is identical.
6. Make necessary changes and then run the cell. All code will be executed, including refreshing the source data set and applying a test function invocation on the first 100 rows of the table.
7. When your UDF is fixed, click the Copy to UDF Editor button if you have one at the bottom of the cell containing your Map UDF, and then save the module in the UDF Panel.
Any additional questions on the process?