Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create list boxes with the list of Tables and associated fields

I am connecting to a SalesForce DB. Done.

Now, I want to load all fields from all tables:

What is the script that I need to use ?

After that, I want to create two list boxes showing the Tables (1) and the Fields (2) so I can expose which field is associated to which Table.

Who can help me doing that ?

Thanks in advance !

10 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP


jeffrobertz wrote:I would find it logical, when you create a new application, by starting to load the 'tables titles' and related 'fields tables' to get familiar with the DB, without looking at the value !


Jeff, this sounds very logical, and there are some tools for that:

1. "Select" wizard provides that functionality and is working well for small databases.

2. Most databases and their ODBC drivers support standard sql commands:

SQLTABLES;

SQLCOLUMNS;

However, I must say - in real life we are often connecting to huge ERP systems like SAP and JDE - they have so many tables and fields that it is not practical to learn their structures by browsing their tables... You need to know or ask someone who knows, to identify the dozen or so tables that you actually need.

I hope it makes sense...

Oleg