topic Re: Field Names into New Table in QlikView

Field Names into New Table

cspencer3 — Tue, 18 Nov 2014 16:00:18 GMT

Is there a way to get the field names of tables previously loaded in the load script into a new table? I was thinking of maybe some way of using a cross table and a resident load, but I could be completely off the mark. Basically just looking to get the names of each field as rows of a new table. I know in SQL you can get field values using system schema tables, but unfamiliar if there is a way in QlikView.

Re: Field Names into New Table

datanibbler — Tue, 18 Nov 2014 16:10:29 GMT

Hi,

sure: You can use the NoOfFields() function to find out how many fields the table you have just loaded has and then use the FieldName() function in a loop to add to a new table the name of every field in that table.

Do all that in a FOR EACH loop or in a subroutine if you have several tables to process.

HTH

Best regards,

DataNibbler

Re: Field Names into New Table

marcus_sommer — Tue, 18 Nov 2014 16:12:04 GMT

You could use table functions like nooffields() and fieldname(). Maybe in a loop through nooftables().

- Marcus

Re: Field Names into New Table

nagaiank — Tue, 18 Nov 2014 16:14:50 GMT

Did you try generating the 'System Table' which has the information on all the tables and fields?

Re: Field Names into New Table

rustyfishbones — Tue, 18 Nov 2014 16:16:58 GMT

Hi Charles,

Are you trying to then store the Field Names into a qvd file?

Where are you taking the Data from? Is it a DB or a QVD file

Regards

Alan

Re: Field Names into New Table

rustyfishbones — Tue, 18 Nov 2014 16:24:08 GMT

Hi Charles,

You could try using SQLCOLUMNS;

CONNECT to ......

Test:

SQLCOLUMNS;

STORE Test INTO Test.qvd(qvd);

You will get a file with details of the Tables and fields from the Database you are connecting to.

I hope that helps

Regards

Alan

example image below

Re: Field Names into New Table

cspencer3 — Tue, 18 Nov 2014 16:52:17 GMT

I am pulling data from a SQL Server Database, and I would just be storing and using those fields in the QVW itself. It looks like you guys all have great answers. I think that Data nibbler is the best option, and although it is a bit more complex than using the SQLColumns method, it gets only column names that are in my QVW not the whole DB. I really like the SQLColumns feature though, and it opens up a whole bunch of other data that may be useful in the future. Thanks Everyone!