topic Re: Export all qvw's field names qualified without using Qualify in the script... in QlikView

Export all qvw's field names qualified without using Qualify in the script...

Marcos_Ferreira_dos_Santos — Thu, 19 Apr 2018 22:48:23 GMT

Hi experts,

I want to export the qualified field names (Table.Field) of one given application, but its script doesn't have the Qualify * command in it, hence the export option gives me only one file with all the Fields and other with all the Tables.

Is there a parameter to do that within the Document ? Any workaround suggested ?

Thank you in advance by the attention,

Best regards,

Marcos

Qlikview version: 11.20.12904.0 SR12

Re: Export all qvw's field names qualified without using Qualify in the script...

felipedl — Fri, 20 Apr 2018 12:31:34 GMT

Hi Marcos,

THe following code gets the field name and tables associated with it.

Just add a table with the both generated fields of the new table and export it. THe names are "qualified" by table name.

load * Inline

[

Prestador,Internações, Partos

AAA, 4,1

BBB, 5, 4

CCC, 5, 3

DDD, 6, 2

];

Load * Inline

[

FieldA,FieldB

1,2

3,4

];

for i = 0 to NoOfTables()-1

let vTest = TableName(i);

for j = 1 to NoOfFields('$(vTest)')

tableNameFields:

Load

'$(vTest)' as [Table Name],

'$(vTest).' & FieldName($(j),'$(vTest)') as [Field Name]

AutoGenerate(1);

next j;

next i;

Result:

Felipe.

Re: Export all qvw's field names qualified without using Qualify in the script...

Marcos_Ferreira_dos_Santos — Fri, 20 Apr 2018 13:37:23 GMT

Hi Felip,

Thank you for your contribution, it helped me a lot.

In fact, a friend of mine today did come up with a simpler solution: generate an object Table wih the fields $Table and $Field, in the Document to reverse engineer, then export to a txt/csv file.

Re: Export all qvw's field names qualified without using Qualify in the script...

felipedl — Fri, 20 Apr 2018 14:08:46 GMT

That might be the case, but unless you qualify the table, you'll have to make the transformation outside.

It's another way to do it too.

Felipe.

Re: Export all qvw's field names qualified without using Qualify in the script...

Peter_Cammaert — Fri, 20 Apr 2018 14:09:34 GMT

Open the document from which you want to export all fields in a "qualified" format in QV Desktop.

Add a listbox using New Sheet Object->List Box..., but instead of selecting a field to display, you navigate to the bottom of the field list and select <Expression>. An expression editor window will pop-up. Enter something like the following expression (vary the layout according to your requirements):

='[' & $Table & '.' & $Field & ']'

Close the properties dialog. A listbox with qualified field names will be shown on your sheet. From the Listbox right-mouse-button-menu, select Send to Excel...

Tada !

Re: Export all qvw's field names qualified without using Qualify in the script...

Marcos_Ferreira_dos_Santos — Fri, 20 Apr 2018 15:23:22 GMT

Fantastic Peter,

Thank you very much for this contribution. Very useful tip!