problem with columns that are deleted from Source and that belong to some ETL filter

[Syndicate_Admin]

Hello, I have the following problem:

I have a data source (API) where the structure of the data is modified many times. The specific problem is that the columns returned by the source are eliminated many times, which affects the filters applied within the ETL.
For example, I try to apply a filter where the column "NameSpecies"= NombSpecies, but if this column is deleted I get rid of all the ETL created, but there is also another column called "RealSpeciesName" that returns the same data as "SpeciesName".

This is why I ask, IF there is a way to generate some logic that allows me to filter by one or another column based on whether it exists or not, so that when they delete one of the columns it generates the filter based on the other column that brings the same data. (generate some kind of Security)


example:
If SpeciesName exists then "SpeciesName" = SpeciesName, if not then "RealSpeciesName"=SpeciesNameSpecies exists.


Thank you so much for your time and help!

[Idrissshatila]

Hello @Syndicate_Admin ,

it won't work because how power bi would know which is the column you want to use, there's no logic to implement that will work automatically, you should be the one that knows which and set it up.