Olá Thiago, está em qvw
Mas copio aqui a linha de comando comentada
det:
LOAD nItem,
as ,
as ,
as orig,
as CSOSN,
as cProd,
as cEAN,
as xProd,
as NCM,
as CEST,
as CFOP,
as uCom,
as qCom,
as vUnCom,
,
as uTrib,
as qTrib,
as vUnTrib,
as indTot,
,
%Key_nfeProc_743443655465363OD // nesta chave está alguma referencia ao nome do arquivo, que nao consigo linkar quando é um soh funciona
FROM (XmlSimple, Table is );
nfeProc:
LOAD versao,
xmlns,
,
as ,
as verAplic,
as chNFe,
as dhRecbto,
as nProt,
as digVal,
as cStat,
as xMotivo,
,
as ,
as SignatureValue,
as X509Certificate,
as URI,
as DigestValue,
as ,
as ,
as ,
as qrCode,
as ,
as Id,
as tPag,
as vPag,
as modFrete,
as vBC,
as vICMS,
as vICMSDeson,
as vFCPUFDest,
as vBCST,
as vST,
as ,
as vFrete,
as vSeg,
as ,
as vII,
as vIPI,
as vPIS,
as vCOFINS,
as vOutro,
as vNF,
as CNPJ,
as xNome,
as xFant,
as IE,
as CRT,
as xLgr,
as nro,
as xCpl,
as xBairro,
as cMun,
as xMun,
as UF,
as CEP,
as cPais,
as xPais,
as fone,
as cUF,
as cNF,
as natOp,
as indPag,
as mod,
as serie,
as nNF,
as dhEmi,
as tpNF,
as idDest,
as cMunFG,
as tpImp,
as tpEmis,
as cDV,
as ,
as finNFe,
as indFinal,
as indPres,
as procEmi,
as verProc,
%Key_nfeProc_743443655465363OD // Key for this table: nfeProc
FROM (XmlSimple, Table is );
Quando pego um arquivo só XML ele link correto apresentando do jeito que eu preciso, pois a chave bate. FROM (XmlSimple, Table is );
Porem preciso pegar vários arquivos XML e referenciar genericamente, estou tentando com concatenate, porem estou fazendo algo errado e não vai.
A única chave que se cria é uma que remete ao nome do arquivo.
Espero ter sido mais claro.
Obrigado
De: THIAGO TEIXEIRA
Enviada em: quarta-feira, 7 de março de 2018 17:45
Para: juliano amantea
Assunto: Re: - Como unir XMLs sem Keys idênticas
Qlik Community <https://community.qlik.com/resources/images/palette-1004/headerLogo-1391206184624-QlikCommunity_logo.gif>
.png "Luminary Alumni"){kind=icon}
