Forum Discussion
Split table based on column value, transform, combine back
Hi itskool
In Transform Sample File, remove "Changed Type" steps which will refer to columns which are named with dates. Select the common columns and select Unpivot Other Columns option.
Do other transformation operations after unpivoting. This could avoid referring to a column by date name.
In the combined query, remove "Changed Type" step too. Only remain steps from the beginning to Expanded Table Column.
You need to check both Transform Sample File query and Combined query to see if there is any step referring to those date columns by column name. This will cause the error you showed.
If you don't know how to deal with some steps, you can open Advanced Editor and paste its code here after removing sensitive info. Then we can review the transformation steps and try to modify some steps to overcome this.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi itskool
In Transform Sample File, remove "Changed Type" steps which will refer to columns which are named with dates. Select the common columns and select Unpivot Other Columns option.
Do other transformation operations after unpivoting. This could avoid referring to a column by date name.
In the combined query, remove "Changed Type" step too. Only remain steps from the beginning to Expanded Table Column.
You need to check both Transform Sample File query and Combined query to see if there is any step referring to those date columns by column name. This will cause the error you showed.
If you don't know how to deal with some steps, you can open Advanced Editor and paste its code here after removing sensitive info. Then we can review the transformation steps and try to modify some steps to overcome this.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you so much, it worked!
Unpivot Other Columns option did the trick.