topic Get fields for all table by macro in QlikView

Get fields for all table by macro

Wed, 09 Dec 2009 15:58:16 GMT

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

Wed, 09 Dec 2009 16:05:14 GMT

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.

Wed, 09 Dec 2009 16:15:44 GMT

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.

Wed, 09 Dec 2009 16:52:24 GMT

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

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

Wed, 09 Dec 2009 18:32:39 GMT

Ok, I solve with SrcTable method.

Thanks to all

kevinpintokpa — Mon, 18 Feb 2013 18:26:30 GMT

Hi Stefano,

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

Thanks!

Kevin