attrep_audit_table giving empty values in schema_name column

[fayaz_syed_two]

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?

[john_wang · Accepted solution]

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.

[fayaz_syed_two]

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

[john_wang]

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