Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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?

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.