topic Re: attrep_audit_table giving empty values in schema_name column in Qlik Replicate

attrep_audit_table giving empty values in schema_name column

fayaz_syed_two — Mon, 18 Mar 2024 00:59:31 GMT

Hi,

I am using a flat file as source and target snowflake.

QR is installed in Linux and controlled from QEM on windows.

I have defined change processing to be captured in attrep_audit_table under the same schema that the table loads into and the other attrep* tables.

Why is schema_name column having emtpy values?

Re: attrep_audit_table giving empty values in schema_name column

john_wang — Mon, 18 Mar 2024 01:15:34 GMT

Hello @fayaz_syed_two ,

Thanks for reaching out to Qlik Community!

"Schema" is typically used in RDBMS, it's meaningless in File source, for example when we select tables in design, the schema is empty for File source tables. If we try to drop down the "Schemas" available list, nothing returned.

You may assign schema name to each target side table in the task, there are 2 options: in table level, or global transformation level.

Table level (in table settings):

Global rule level:

Hope this helps.

John.

Re: attrep_audit_table giving empty values in schema_name column

fayaz_syed_two — Mon, 18 Mar 2024 01:47:54 GMT

Thanks much for your quick response and clarification John! This solution worked.

Re: attrep_audit_table giving empty values in schema_name column

john_wang — Mon, 18 Mar 2024 02:18:36 GMT

Glad to hear that @fayaz_syed_two , thank you so much for your great support!