Export to TXT

[#1]

how to export a table to a file .txt and eliminate some columns that are not necessary
? for example , i have a pivot table with 3 dimensions and 7 expressions , but I only need to export 2 dimensions to create a new interface with another system . I am using the code below, but have exported all dimensions and expressions, is there a way to eliminate one dimension ?

SUB Export_GKO
VarDir = "c:"
rem VarDir = "c:\HORIMETROS"
msgbox "Preparing Interface.",VbOkonly,"GKO:"
Set olTabela = ActiveDocument.Sheets("GKO SAÍDA").SheetObjects("GKO_INTERFACE_SAIDA")
olTabela.Export VarDir & "FRDNE.txt", "#"
rem ActiveDocument.Reload
End Sub

[Oleg_Troyansky]

The easiest way is to have a hidden Pivot Table with less dimensions and less expressions and use that for the export. What you exporting doesn't have the be the same object as the one that the user will see...

[hectorgarcia]

if you are in qv9 you can do that in the script with store command. it is too powerful to this kind of tasks that generates info for other systems.

Hector

[surender_mehta]

Creating another chart with less dimension and expression as required to export , set its layout below then the one sould be visible on the screen, call it via actions when exporting

[#5]

I appreciate all feedbacks but in my case i can´t delete dimensions because will affect directly the logic envolved in the chart. I ´m studying other possibilites. best regards

[llauses243]

Hi all,

Napoleon: Divide for win

popular phrase: Clone for adapt, no touch if func ¡¡

explain: clone your object and to prepare for export