Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Invoked custom column

Hi everybody,

 

I'm copying from the advance editor all the steps from the file of a colleague of mine. Unfortunately, it returns me an error.

 

Therefore, I went backward to check alll the steps and I figured out that the second step, an invoke custom column is perceived as a normal custom column. Hence, I decided to insert a brand new step and invoke a custom column  but it looks like I cannot select the function query. Any explanations and suggestions?

 

  • This video illustrates how to copy AND how it solves the issue:

10 Replies

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion

    Probably you don't have the custom function.

     

    If you copy a query, it is better to right-click the query, choose copy, and paste in the query editor of the destination file.

     

    This will copy/paste the query plus all related queries, like the custom function in your case.

     

    If you copy/paste the query steps, then you will only get the query steps; not any related queries.

     

    For now I would suggest to copy/paste the custom function as well.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi MarcelBeug,

       

      what I did was to copy and paste the steps from the advance editor in the query editor.

       

      As you can see from the file attached, the second step should be a Invoke custom columns but it's not.

       

      • MarcelBeug's avatar
        MarcelBeug
        Community Champion

        That is exactly what I tried to explain: because you didn't copy the function, the step isn't recognized as a step in which a custom function is invoked.

        And that is why you get the error message, because "Transform File from ESDS (2)" doesn't exist

         

        So just go back to your colleague and copy his "Transform File from ESDS (2)" function and paste it in your file.