column referenced isn't found but exists in the connector

AnnieL
AnnieL ⚪️
in Dataflows

In ETL formula tab I am trying to rewrite a column name and am getting an error that says the column referenced isn't found. The column name pops up in the list of available columns to re write but then errors when I try to validate the formula. Is there any fix to find this column?

Screenshot 2022-04-06 111235.png


Tagged:

Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    Try clicking on Run Preview and see if that helps the ETL recognize what columns actually exist. You can also use the expanded formula editor and double-click the column in the list to add it to the formula editor to ensure there are no typos.



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

    thank you!! found out there was a space in front of the column name when I added it from the list in the expanded editor.

Categories