How To Create Files

[#1]

HI,

Kindly guide me how to creat given below files:

.qvw.Tables.tab

.qvw.Fields.tab

.qvw.Mappings.tab

Regards,

Zain.

[Gysbert_Wassenaar · Accepted solution]

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

[#3]

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;

[Gysbert_Wassenaar]

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.

[#5]

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

Regards,

Zain.

[stevedark]

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