Forum Discussion
Error: column wasn't found
Hi everyone, I'm encountering an issue while refreshing my dataflow, specifically during the "WriteToDataDestination" activity. In my query, I combined several tables using the "Append Queries as...
You will want to unpivot your source tables BEFORE you append them.
Can you post a couple rows from each source table?
My source tables are somewhat messy, but they follow the exact same format. There are more than 10 columns in each source table, including time, budget, revenue, percentage, etc. Shall I clean/transform and unpivot all source tables and then append all together?
I cannot assist you if you are unable to provide sample data. I hope someone else can help you further.