topic Re: How To Create Files in QlikView

How To Create Files

Thu, 12 Mar 2015 11:11:15 GMT

HI,

Kindly guide me how to creat given below files:

.qvw.Tables.tab

.qvw.Fields.tab

.qvw.Mappings.tab

Regards,

Zain.

Re: How To Create Files

Gysbert_Wassenaar — Thu, 12 Mar 2015 11:29:53 GMT

Open the Table Viewer and choose Export Structure from the File menu

Re: How To Create Files

Thu, 12 Mar 2015 11:43:46 GMT

Dear, its hasn't create .qvw.tables.tab, its create .qvw.tables, so due to this its not execute given below script.

Tables:

LOAD
1 as TableCount,
hash128(mid(filename(), 1, index(filename(), '.') - 1) & ':' & TableName) as TableKey,
mid(filename(), 1, index(filename(), '.') - 1) as [Source QVW File],
TableName as [Table Name],
Loose,
#Records as [Records],
#Fields as [Fields],
#Keys as [Keys]
FROM[$(vDataFolder)*.qvw.Tables.tab]
(txt, codepage is 1252, embedded labels, delimiter is'\t', msq);

let vNoOfRows = alt(NoOfRows('Tables'), 0) + vNoOfRows;

Re: How To Create Files

Gysbert_Wassenaar — Thu, 12 Mar 2015 11:47:11 GMT

Make sure that your Windows installation is not hiding the extension of files in Explorer. Also make sure that $(vDataFolder) is set to where you saved the .tab files.

Re: How To Create Files

Thu, 12 Mar 2015 11:55:20 GMT

Thanks Gysbert, I made mistake in path, now its work fine.

Regards,

Zain.

Re: How To Create Files

stevedark — Sun, 15 Mar 2015 11:28:09 GMT

Hi Zain,

If you would like to download an application to view these files, or find out ways in which you can use them to build better Qlik applications you should see this blog post:

http://bit.ly/1GDS6TH

Hope it is of interest to you.

Steve