Do I have the right code in my Python Script?

giannzi
giannzi Member
in Magic ETL

Hi,

Select Columns 2 has four columns, they are EFFDT, ACAD_PLAN, DESCR, and ACAD_CAREER. I wrote a Python script to filter the EFFDT column so that it only includes rows where the value is 'A'.

However, when I try to join this dataset with another, I receive an error stating that the referenced column, which is the ACAD_PLAN cannot be found.

Is there something wrong with my code? I’d appreciate any guidance on resolving this issue.

Thanks!

image.png image.png
Tagged:

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    If you want to just include rows where that column equals, it would be easier to just use a filter tile and do the filter there. Just drag in the filter tile and connect it to the select columns 2 tile and add formula rule and use the following formula EFFDT = 'A'

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • ggenovese
    ggenovese Coach

    Check your schema in your python tile and ensure that 'ACAD_PLAN' is included in the output

Categories