Expression.Error: The column 'xyz' of the table wasn't found.

[toafk]

I'm working on a XML file. Some columns have values and "table".

I'm trying to transform it like this.

For step1 I get this message. Expression.Error: The column 'xyz' of the table wasn't found.
What am I doing wrong?

[Payeras_BI]

Hi @toafk ,

Instead of skipping steps, is not substituting Source by #"Renamed Columns" in your step1 what you are looking for? Otherwise, you cannot refer to any column name product of the transformations in between Source and step1.

[toafk]

Yes, but if I skip the rename column, I get 
"Expression.Error: The column 'Sites.Site.ServiceUnits.ServiceUnit.Resources.Resource.Description' of the table wasn't found.Expression.Error: The column 'Sites.Site.ServiceUnits.ServiceUnit.Resources.Resource.Description' of the table wasn't found."

[Payeras_BI]

Hi @toafk ,
In step1 is your intention to apply the transformation over the "Source"?
Your column got the "xyz" name, later, in the #"Renamed Columns" step.

[toafk · Accepted solution]

Found the solution. It was the use of "Source" that I had totally misunderstood. Thanks for helping me find it.