Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
peter_turner
Partner - Specialist
Partner - Specialist

System Tables from a Binary load?

Hello!

I have a field name XYZ (which is variable), and i need to find which table it belongs to, so my script can look something like this...

LOAD
Stuff
Resident $(The table name i dont know)

I am doing a Binary Load of my QV source data anyway, so is there a way to see the $System tables from the source QVW?

Labels (1)
2 Replies
renjithpl
Specialist
Specialist

Hi Peter,

Are you talking about system table ?

if so, when you right click -> go to New sheet object, -> select system table.

Thanks

Ren

peter_turner
Partner - Specialist
Partner - Specialist
Author

Hi,

I am talking about the the system table, but i need that exact information available to my script.

Unfortunately that table is only created once the script has complete, but as I'm doing a binary load on an existing qvw, I'm hoping to be able to get access to that existing file's system table.

Or,

Some method to find out what table a field is in.

Thanks,
Peter.