Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
caiqueeloy93
Contributor III
Contributor III

Como editar a programação de um arquivo QVD ?

Boa noite,

 

Estou com seguinte problema ... Tenho arquivos QVDS mas nao consigo abrir a programação que foi feita pra gerar esse arquivo qvd e eu precisava editar parametros dessa programação, os outros qvd´s quando abertos no qlik geralmente mostram a programação em SQL feita, mas esses QVD´S em especifico não ...

 

Alguem sabe como posso fazer pra editar essa programação?

 

Att

1 Solution

Accepted Solutions
elvis_schwarz
Creator
Creator

Você está usando Qlik Sense certo?

Crie uma conexão para a pasta onde está salvo o QVD em seguida clique em selecionar os dados e navegue até onde o arquivo está salvo e selecione ele, a partir deste momento você já vai ter um script para subir todos os dados que estão armazenados. Se estiver tudo ok com seu Qlik Sense você não terá dificuldades para ler e editar o aqrquivo

View solution in original post

6 Replies
marco_almeida
Creator II
Creator II

Cara, está um pouco confusa a sua dúvida. O que você quer dizer com "programação"?
Grupo Telegram Qlik Brasil: https://t.me/joinchat/AeRmnUmcxQ02L00g3x-HtQ
guisato001
Contributor III
Contributor III

Bom dia!

Na verdade o QVD é uma forma de armazenar os dados. Ele não tem um script SQL, somente dados.

Acredito que você esteja falando de alguma aplicação que use os dados desse QVD. 
Se você quiser encontrar o QVS que gera o QVD, precisa encontrar a aplicação que tenha um {STORE...INTO... xxx.QVD}. Se no Script você encontrar isso é porque ele esta gerando um arquivo QVD.

marco_almeida
Creator II
Creator II

@guisato001 , se você abrir o QVD em um editor de texto com suporte XML consegue verificar tudo o que foi feito, inclusive o script que o gerou. O QVD armazena, além de dados, metadados.

Grupo Telegram Qlik Brasil: https://t.me/joinchat/AeRmnUmcxQ02L00g3x-HtQ
pedromsouza
Creator II
Creator II

Vale uma postagem no blog! Com um exemplo e tal. Muito útil. 

Qliking since '09
caiqueeloy93
Contributor III
Contributor III
Author

Galera, abri o arquivo com um programa chamado Q-Eye do qliksense e exebi os metadados ...

 

Segue metadados ( Agora queria saber como editar esses metadados em XML )

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<QvdTableHeader>
<QvBuildNo>50504</QvBuildNo>
<CreatorDoc>cae0df4f-7395-4fed-9a8a-0befbde2b1df</CreatorDoc>
<CreateUtcTime>2019-06-17 22:35:51</CreateUtcTime>
<SourceCreateUtcTime></SourceCreateUtcTime>
<SourceFileUtcTime></SourceFileUtcTime>
<SourceFileSize>-1</SourceFileSize>
<StaleUtcTime></StaleUtcTime>
<TableName>Estoque_Galpao</TableName>
<Fields>
<QvdFieldHeader>
<FieldName>Código Galpão</FieldName>
<BitOffset>0</BitOffset>
<BitWidth>16</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>UNKNOWN</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt></Fmt>
<Dec></Dec>
<Thou></Thou>
</NumberFormat>
<NoOfSymbols>7722</NoOfSymbols>
<Offset>0</Offset>
<Length>162148</Length>
<Comment></Comment>
<Tags></Tags>
</QvdFieldHeader>
<QvdFieldHeader>
<FieldName>Num_Galpao</FieldName>
<BitOffset>16</BitOffset>
<BitWidth>8</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>UNKNOWN</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt></Fmt>
<Dec></Dec>
<Thou></Thou>
</NumberFormat>
<NoOfSymbols>37</NoOfSymbols>
<Offset>162148</Offset>
<Length>185</Length>
<Comment></Comment>
<Tags></Tags>
</QvdFieldHeader>
<QvdFieldHeader>
<FieldName>Iteracao</FieldName>
<BitOffset>24</BitOffset>
<BitWidth>13</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>UNKNOWN</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt></Fmt>
<Dec></Dec>
<Thou></Thou>
</NumberFormat>
<NoOfSymbols>6403</NoOfSymbols>
<Offset>162333</Offset>
<Length>62933</Length>
<Comment></Comment>
<Tags></Tags>
</QvdFieldHeader>
<QvdFieldHeader>
<FieldName>AnoMes</FieldName>
<BitOffset>0</BitOffset>
<BitWidth>0</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>UNKNOWN</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt></Fmt>
<Dec></Dec>
<Thou></Thou>
</NumberFormat>
<NoOfSymbols>1</NoOfSymbols>
<Offset>225266</Offset>
<Length>12</Length>
<Comment></Comment>
<Tags></Tags>
</QvdFieldHeader>
<QvdFieldHeader>
<FieldName>Filial</FieldName>
<BitOffset>0</BitOffset>
<BitWidth>0</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>UNKNOWN</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt></Fmt>
<Dec></Dec>
<Thou></Thou>
</NumberFormat>
<NoOfSymbols>1</NoOfSymbols>
<Offset>225278</Offset>
<Length>6</Length>
<Comment></Comment>
<Tags></Tags>
</QvdFieldHeader>
<QvdFieldHeader>
<FieldName>Largura</FieldName>
<BitOffset>72</BitOffset>
<BitWidth>8</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>REAL</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt></Fmt>
<Dec>,</Dec>
<Thou>.</Thou>
</NumberFormat>
<NoOfSymbols>72</NoOfSymbols>
<Offset>225284</Offset>
<Length>751</Length>
<Comment></Comment>
<Tags></Tags>
</QvdFieldHeader>
<QvdFieldHeader>
<FieldName>Altura</FieldName>
<BitOffset>0</BitOffset>
<BitWidth>0</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>REAL</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt></Fmt>
<Dec>,</Dec>
<Thou>.</Thou>
</NumberFormat>
<NoOfSymbols>1</NoOfSymbols>
<Offset>226035</Offset>
<Length>7</Length>
<Comment></Comment>
<Tags></Tags>
</QvdFieldHeader>
<QvdFieldHeader>
<FieldName>Comprimento</FieldName>
<BitOffset>64</BitOffset>
<BitWidth>8</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>REAL</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt></Fmt>
<Dec>,</Dec>
<Thou>.</Thou>
</NumberFormat>
<NoOfSymbols>168</NoOfSymbols>
<Offset>226042</Offset>
<Length>1553</Length>
<Comment></Comment>
<Tags></Tags>
</QvdFieldHeader>
<QvdFieldHeader>
<FieldName>Prioridade</FieldName>
<BitOffset>37</BitOffset>
<BitWidth>13</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>REAL</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt></Fmt>
<Dec>,</Dec>
<Thou>.</Thou>
</NumberFormat>
<NoOfSymbols>6403</NoOfSymbols>
<Offset>227595</Offset>
<Length>32017</Length>
<Comment></Comment>
<Tags></Tags>
</QvdFieldHeader>
<QvdFieldHeader>
<FieldName>Descrição Galpão</FieldName>
<BitOffset>50</BitOffset>
<BitWidth>14</BitWidth>
<Bias>0</Bias>
<NumberFormat>
<Type>UNKNOWN</Type>
<nDec>0</nDec>
<UseThou>0</UseThou>
<Fmt></Fmt>
<Dec></Dec>
<Thou></Thou>
</NumberFormat>
<NoOfSymbols>7719</NoOfSymbols>
<Offset>259612</Offset>
<Length>294234</Length>
<Comment></Comment>
<Tags></Tags>
</QvdFieldHeader>
</Fields>
<Compression></Compression>
<RecordByteSize>10</RecordByteSize>
<NoOfRecords>7722</NoOfRecords>
<Offset>553846</Offset>
<Length>77220</Length>
<Lineage>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>SQL SELECT
&quot;Z18_FILIAL&quot; AS A2_FILIAL,
&quot;Z18_DATA&quot; AS A2_DATA,
&quot;Z18_QTDE&quot; AS A2_QTDE,
&quot;Z18_LARGUR&quot; AS A2_LARGUR,
&quot;Z18_COMPRI&quot; AS A2_COMPRI,
&quot;Z18_PEDIR&quot; AS A2_PEDIR,
&quot;Z18_TIPO&quot; AS A2_TIPO,
&quot;Z18_M2&quot; AS A2_M2,
&quot;Z18_OBS&quot; AS A2_OBS,
&quot;Z18_CODIGO&quot; AS A2_CODIGO,
'201906' AS [A2_AnoMes]
FROM SDBP12.dbo.Z18T10
WHERE &quot;D_E_L_E_T_&quot; = ''</Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>SQL SELECT &quot;B1_COD&quot;, &quot;B1_GRUPO&quot;, &quot;B1_TIPO&quot;
FROM SDBP12.dbo.SB1T10
WHERE &quot;D_E_L_E_T_&quot; = '' AND &quot;B1_MSBLQL&quot; &lt;&gt; 1 </Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>SQL SELECT &quot;B1_FILIAL&quot;, &quot;B1_DESC&quot;, &quot;B1_COD&quot;, &quot;B1_XSAISLD&quot;, &quot;B1_GRUPO&quot;,
&quot;B1_XLARGUR&quot;, &quot;B1_XCOMPRI&quot;, &quot;B1_PE&quot;, &quot;B1_XORDMNT&quot;, &quot;D_E_L_E_T_&quot;
FROM SDBP12.dbo.SB1T10
WHERE &quot;D_E_L_E_T_&quot; = '' AND &quot;B1_TIPO&quot; = 'PA' AND &quot;B1_MSBLQL&quot; &lt;&gt; 1 </Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>SQL SELECT &quot;B1_FILIAL&quot;, &quot;B1_DESC&quot;, &quot;B1_COD&quot;, &quot;B1_XSAISLD&quot;, &quot;D_E_L_E_T_&quot;
FROM SDBP12.dbo.SB1T10
WHERE &quot;D_E_L_E_T_&quot; = '' AND &quot;B1_TIPO&quot; &lt;&gt; 'PA' and &quot;B1_MSBLQL&quot; &lt;&gt; 1 </Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>SQL SELECT &quot;B2_FILIAL&quot;, &quot;B2_COD&quot;, &quot;B2_LOCAL&quot;, &quot;B2_QATU&quot;, &quot;B2_VATU1&quot;
FROM SDBP12.dbo.SB2T10
WHERE &quot;D_E_L_E_T_&quot; = '' and &quot;B2_LOCAL&quot; in ('A1', 'Q1', 'ME', 'ML')</Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>SQL SELECT &quot;Z17_FILIAL&quot;, &quot;Z17_DTREV&quot;, &quot;Z17_VERSAO&quot;, &quot;Z17_VLATU&quot;,
&quot;Z17_VLRESI&quot;, &quot;Z17_CUSTO&quot;, &quot;Z17_PRODUT&quot;
FROM dbo.Z17T10 </Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>SQL SELECT A.&quot;G1_FILIAL&quot;, A.&quot;G1_COD&quot;, A.&quot;G1_COMP&quot;, A.&quot;G1_QUANT&quot;
FROM SDBP12.dbo.SG1T10 AS A INNER JOIN

(
SELECT &quot;G1_FILIAL&quot;, &quot;G1_COD&quot;, &quot;G1_COMP&quot;, MAX(G1_REVFIM) AS G1_REVFIM
FROM SDBP12.dbo.SG1T10
WHERE &quot;D_E_L_E_T_&quot; = ''
GROUP BY &quot;G1_FILIAL&quot;, &quot;G1_COD&quot;, &quot;G1_COMP&quot;
) AS B
ON A.G1_FILIAL = B.G1_FILIAL AND A.G1_COD = B.G1_COD AND A.G1_COMP = B.G1_COMP AND A.G1_REVFIM = B.G1_REVFIM
WHERE A.&quot;D_E_L_E_T_&quot; = ''</Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>TAB_A2:
LOAD * ;SQL SELECT
&quot;Z18_FILIAL&quot; AS A2_FILIAL,
&quot;Z18_DATA&quot; AS A2_DATA,
&quot;Z18_QTDE&quot; AS A2_QTDE,
&quot;Z18_LARGUR&quot; AS A2_LARGUR,
&quot;Z18_COMPRI&quot; AS A2_COMPRI,
&quot;Z18_PEDIR&quot; AS A2_PEDIR,
&quot;Z18_TIPO&quot; AS A2_TIPO,
&quot;Z18_M2&quot; AS A2_M2,
&quot;Z18_OBS&quot; AS A2_OBS,
&quot;Z18_CODIGO&quot; AS A2_CODIGO,
'201906' AS [A2_AnoMes]
FROM SDBP12.dbo.Z18T10
WHERE &quot;D_E_L_E_T_&quot; = ''</Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>[CADASTRO_COMPONENTES]:
LOAD
&quot;B1_FILIAL&quot; as [Filial],
&quot;B1_COD&quot; as [Código Componente],
&quot;B1_DESC&quot; as [Descrição Componente],
&quot;B1_XSAISLD&quot; AS [Usar];SQL SELECT &quot;B1_FILIAL&quot;, &quot;B1_DESC&quot;, &quot;B1_COD&quot;, &quot;B1_XSAISLD&quot;, &quot;D_E_L_E_T_&quot;
FROM SDBP12.dbo.SB1T10
WHERE &quot;D_E_L_E_T_&quot; = '' AND &quot;B1_TIPO&quot; &lt;&gt; 'PA' and &quot;B1_MSBLQL&quot; &lt;&gt; 1 </Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>[CADASTRO_PRODUTO_ACABADO]:
LOAD

&quot;B1_COD&quot; as [Código Galpão],
&quot;B1_DESC&quot; as [Descrição Galpão],
&quot;B1_XORDMNT&quot; as [Prioridade],
&quot;B1_XLARGUR&quot; as [Largura],
&quot;B1_XCOMPRI&quot; as [Comprimento],
&quot;B1_GRUPO&quot; as Grupo,
&quot;B1_PE&quot; as [Pé Direito];SQL SELECT &quot;B1_FILIAL&quot;, &quot;B1_DESC&quot;, &quot;B1_COD&quot;, &quot;B1_XSAISLD&quot;, &quot;B1_GRUPO&quot;,
&quot;B1_XLARGUR&quot;, &quot;B1_XCOMPRI&quot;, &quot;B1_PE&quot;, &quot;B1_XORDMNT&quot;, &quot;D_E_L_E_T_&quot;
FROM SDBP12.dbo.SB1T10
WHERE &quot;D_E_L_E_T_&quot; = '' AND &quot;B1_TIPO&quot; = 'PA' AND &quot;B1_MSBLQL&quot; &lt;&gt; 1 </Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>[CUSTO_STANDART]:
LOAD Z17_FILIAL as Filial,
Z17_DTREV as [Data Revisão],
Z17_VERSAO as [Versão],
Z17_VLATU as [Valor Atual],
Z17_VLRESI as [Valor Residual],
Z17_CUSTO as [Custo Standart],
Z17_PRODUT as [Código Componente];SQL SELECT &quot;Z17_FILIAL&quot;, &quot;Z17_DTREV&quot;, &quot;Z17_VERSAO&quot;, &quot;Z17_VLATU&quot;,
&quot;Z17_VLRESI&quot;, &quot;Z17_CUSTO&quot;, &quot;Z17_PRODUT&quot;
FROM dbo.Z17T10 </Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>[ESTRUTURA_PRODUTO_ACABADO]:
LOAD
&quot;G1_COD&quot; as [Código Galpão],


if(&quot;G1_COMP&quot;='44204202012','44204202029',&quot;G1_COMP&quot;)
as [Código Componente],
&quot;G1_QUANT&quot; as [Quant Utilizada];SQL SELECT A.&quot;G1_FILIAL&quot;, A.&quot;G1_COD&quot;, A.&quot;G1_COMP&quot;, A.&quot;G1_QUANT&quot;
FROM SDBP12.dbo.SG1T10 AS A INNER JOIN

(
SELECT &quot;G1_FILIAL&quot;, &quot;G1_COD&quot;, &quot;G1_COMP&quot;, MAX(G1_REVFIM) AS G1_REVFIM
FROM SDBP12.dbo.SG1T10
WHERE &quot;D_E_L_E_T_&quot; = ''
GROUP BY &quot;G1_FILIAL&quot;, &quot;G1_COD&quot;, &quot;G1_COMP&quot;
) AS B
ON A.G1_FILIAL = B.G1_FILIAL AND A.G1_COD = B.G1_COD AND A.G1_COMP = B.G1_COMP AND A.G1_REVFIM = B.G1_REVFIM
WHERE A.&quot;D_E_L_E_T_&quot; = ''</Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>[SITUACAO_ESTOQUE_ABERTO]:


LOAD &quot;B2_FILIAL&quot; as [Filial],


if(&quot;B2_COD&quot;='44204202012','44204202029',&quot;B2_COD&quot;)
as [Código Componente],
&quot;B2_LOCAL&quot; as [Armazém],
DATE(TODAY()) as [Data Posição],
&quot;B2_QATU&quot; as [Quantidade Estoque],
&quot;B2_VATU1&quot; as [Preço Estoque];SQL SELECT &quot;B2_FILIAL&quot;, &quot;B2_COD&quot;, &quot;B2_LOCAL&quot;, &quot;B2_QATU&quot;, &quot;B2_VATU1&quot;
FROM SDBP12.dbo.SB2T10
WHERE &quot;D_E_L_E_T_&quot; = '' and &quot;B2_LOCAL&quot; in ('A1', 'Q1', 'ME', 'ML')</Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=ODBC;DSN={DSN=PRD_IN1};</Discriminator>
<Statement>[TIPO_PRODUTO_ACABADO]:
LOAD DISTINCT

&quot;B1_COD&quot; as [Cod_Componente],
&quot;B1_GRUPO&quot; as Grupo,
&quot;B1_TIPO&quot; as [Tipo];SQL SELECT &quot;B1_COD&quot;, &quot;B1_GRUPO&quot;, &quot;B1_TIPO&quot;
FROM SDBP12.dbo.SB1T10
WHERE &quot;D_E_L_E_T_&quot; = '' AND &quot;B1_MSBLQL&quot; &lt;&gt; 1 </Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=INLINE;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT Custo_Standart_A;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT Estoque;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT EstoqueFinal_passo_1;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT Galpao_Passo_1;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT Galpao_Passo_2;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT Galpao_Passo_3;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT PRIORIZAÇÃO;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT Precificação_A_Corp;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT Precificação_A_Filial;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT ROMANEIO;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=RESIDENT ROMANEIO_CHEIO;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_DataMartEstoque (topico_bi.topico)/01 - A1/EstoqueBase_C_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_DataMartEstoque (topico_bi.topico)/01 - A1/EstoqueProdutoAcabado_C_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_DataMartEstoque (topico_bi.topico)/01 - A1/Estoque_Inicial_Produto_C_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_DataMartEstoque (topico_bi.topico)/01 - A1/Preço_Base_C_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_DataMartEstoque (topico_bi.topico)/01 - A1/Preço_Base_F_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_DataMartEstoque (topico_bi.topico)/01 - A1/Preço_Standart_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_DataMartEstoque (topico_bi.topico)/01 - A1/Registro_Utilizacao_C_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_DataMartEstoque (topico_bi.topico)/01 - A1/Romaneio_C_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_DataMartEstoque (topico_bi.topico)/02 - A2/TAB_A2_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_StageEstoque (topico_bi.topico)/CAD_COMPONENTES.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_StageEstoque (topico_bi.topico)/CAD_COMPONENTES_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_StageEstoque (topico_bi.topico)/CAD_PRODUTO_ACABADO_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_StageEstoque (topico_bi.topico)/CUSTO_STANDART_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_StageEstoque (topico_bi.topico)/ESTR_PRODUTO_ACABADO_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_StageEstoque (topico_bi.topico)/MOV_ESTOQUE_FECHADO_201906.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN={STORE - [lib://01_StageEstoque (topico_bi.topico)/TIPO_PRODUTO_ACABADO.qvd] (qvd)};</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=c:\qliksense\01 - datamart\01 - estoque\01 - a1\estoquebase_c_201906.qvd;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=c:\qliksense\01 - datamart\01 - estoque\01 - a1\estoqueprodutoacabado_c_201906.qvd;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=c:\qliksense\01 - datamart\01 - estoque\01 - a1\registro_utilizacao_c_201906.qvd;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=c:\qliksense\02 - stage\01 - estoque\cad_componentes_201906.qvd;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=c:\qliksense\02 - stage\01 - estoque\cad_produto_acabado_201906.qvd;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=c:\qliksense\02 - stage\01 - estoque\custo_standart_201906.qvd;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=c:\qliksense\02 - stage\01 - estoque\estr_produto_acabado_201906.qvd;</Discriminator>
<Statement></Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>DSN=c:\qliksense\02 - stage\01 - estoque\mov_estoque_fechado_201906.qvd;</Discriminator>
<Statement></Statement>
</LineageInfo>
</Lineage>
<Comment></Comment>
</QvdTableHeader>

elvis_schwarz
Creator
Creator

Você está usando Qlik Sense certo?

Crie uma conexão para a pasta onde está salvo o QVD em seguida clique em selecionar os dados e navegue até onde o arquivo está salvo e selecione ele, a partir deste momento você já vai ter um script para subir todos os dados que estão armazenados. Se estiver tudo ok com seu Qlik Sense você não terá dificuldades para ler e editar o aqrquivo