I have setup a data replication task in Qlik Cloud Data Integration, and I'm looking to use one of the provided expression headers to add a column to a table. However, when I use the header in the expression, I get a validation error with the following message: "The column expression is not valid: test. The attribute Q_H_OPERATION does not exist in the source dataset."
My understanding is that the column wouldn't need to exist in the source dataset since it's meant to provide metadata of the source table rather than data of the table. This wasn't an issue when using expression headers in Qlik Replicate for the same purpose.
The replication task has a SQL Server source and SQL Server target. The data movement gateway is version 2026.5.37.
Please let me know if you need any further information. Any insight into the issue is greatly appreciated.