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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get fields for all table by macro

Hi to all,

how can I get the list of all fields for each logical table?

I found GetTableCount, GetTableName, GetTableNumber in the Api.

Is ther a method to get fields for table or to get table for each fields?

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Ok, I solve with SrcTable method.

Thanks to all

View solution in original post

5 Replies
Not applicable
Author

Hi,

Try this in a list box. $Table--> This will give you the list of table you have.

$Field -->This will give you the list of fields in a table.

Thanks

Saran.

Not applicable
Author

Hi,

You must use the system files $Table $Field with the function concat like as follow:

= concat( distinct $Field, ';' )

This let you see all the fields name in a text object.

I hope this help you.

Best regards.

Not applicable
Author

If u are askng fr GUI part then u can get.

in properties select "NewSheetObject" in tht u select "currentSelectionsBox"..

Not applicable
Author

Ok, I solve with SrcTable method.

Thanks to all

kevinpintokpa
Creator II
Creator II

Hi Stefano,

What is the SrcTable method that you refer to?  I searched for it but could not find any information.

Thanks!

Kevin