topic System Tables from a Binary load? in QlikView

System Tables from a Binary load?

peter_turner — Mon, 27 Sep 2010 10:41:07 GMT

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?

System Tables from a Binary load?

renjithpl — Mon, 27 Sep 2010 12:39:41 GMT

Hi Peter,

Are you talking about system table ?

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

Thanks

Ren

System Tables from a Binary load?

peter_turner — Mon, 27 Sep 2010 13:59:44 GMT

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.