title: Qlikview- How to unqualify/concatenate many rows from many differents tables?
body: <p>I have multiple tables and each of them some fields are identical and several others are different. When I try to load them all at the same time the program "hangs" and I have to restart the application. It seems to me that the solution would be to use Qualify and unqualify or another script. I want all fields that are equal be concatenated. however there are tables that contain up to 229 columns.</p>
  
  <p>I need from the key fields that I will be able to concatenate the information without losing the value of each field ..</p>
  
  <p>How should I proceed to make all the same columms that are equal as a "KEY" without to need to list all of them?</p>
  
  <p>this is how iam using the script..  </p>
  
  <pre><code>LOAD Nome as Comarca, 
   Vara, 
   Entrancia, 
   Juiz, 
   Escrivao, 
   NomeMapa, 
   IdComarca, 
   Mes, 
   Ano, 
   MatJuiz, 
   IdVara, 
   IdEscrivao, 
   IdMapa, 
   DataFechamentoJuiz, 
   DataFechamentoEscrivao, 
   TitularRespondendo, 
   AndCausOrdiMesAnt, 
   AndCausOrdiAutu, 
   AndCausOrdiArqui, 
   AndCausOrdiAnda, 
   AndCausSumMesAnt, 
   AndCausSumAutu, 
   AndCausSumArqui, 
   AndCausSumAnda, 
   AndProcCautMesAnt, 
   AndProcCautAutu, 
   AndProcCautArqui, 
   AndProcCautAnda, 
   AndEmbarMesAnt, 
   AndEmbarAutu, 
   AndEmbarArqui, 
   AndEmbarAnda, 
   AndDemaisMesAnt, 
   AndDemaisAutu, 
   AndDemaisArqui, 
   AndDemaisAnda, 
   AndExecTotMesAnt, 
   AndExecTotAutu, 
   AndExecTotArqui, 
   AndExecTotAnda, 
   AndTituloExMesAnt, 
   AndTituloExAutu, 
   AndTituloExArqui, 
   AndTituloExAnda, 
   AndTituloJudMesAnt, 
   AndTituloJudAutu, 
   AndTituloJudArqui, 
   AndTituloJudAnda, 
   AndExecFiscMesAnt, 
   AndExecFiscAutu, 
   AndExecFiscArqui, 
   AndExecFiscAnda, 
   AndFedMesAnt, 
   AndFedAutu, 
   AndFedArqui, 
   AndFedAnda, 
   AndEstMesAnt, 
   AndEstAutu, 
   AndEstArqui, 
   AndEstAnda, 
   AndMuniMesAnt, 
   AndMuniAutu, 
   AndMuniArqui, 
   AndMuniAnda, 
   AndFalenMesAnt, 
   AndFalenAutu, 
   AndFalenArqui, 
   AndFalenAnda, 
   AndProcJuriMesAnt, 
   AndProcJuriAutu, 
   AndProcJuriArqui, 
   AndProcJuriAnda, 
   AndAcoPrevMesAnt, 
   AndAcoPrevAutu, 
   AndAcoPrevArqui, 
   AndAcoPrevAnda, 
   AndInciMesAnt, 
   AndInciAutu, 
   AndInciArqui, 
   AndInciAnda, 
   AndAcoIndeMesAnt, 
   AndAcoIndeAutu, 
   AndAcoIndeArqui, 
   AndAcoIndeAnda, 
   AndMandaMesAnt, 
   AndMandaAutu, 
   AndMandaArqui, 
   AndMandaAnda, 
   AndAcaCivMesAnt, 
   AndAcaCivAutu, 
   AndAcaCivArqui, 
   AndAcaCivAnda, 
   AndAcoTrabMesAnt, 
   AndAcoTrabAutu, 
   AndAcoTrabArqui, 
   AndAcoTrabAnda, 
   AndOutMesAnt, 
   AndOutAutu, 
   AndOutArqui, 
   AndOutAnda, 
   AndTotalMesAnt, 
   AndTotalAutu, 
   AndTotalArqui, 
   AndTotalAnda, 
   AndPrecMesAnt, 
   AndPrecAutu, 
   AndPrecArqui, 
   AndPrecAnda, 
   AndExecMesAnt, 
   AndExecAutu, 
   AndExecArqui, 
   AndExecAnda, 
   AndExecPenMesAnt, 
   AndExecPenAutu, 
   AndExecPenArqui, 
   AndExecPenAnda, 
   AndExecSuspMesAnt, 
   AndExecSuspAutu, 
   AndExecSuspArqui, 
   AndExecSuspAnda, 
   AndExecFisMesAnt, 
   AndExecFisAutu, 
   AndExecFisArqui, 
   AndExecFisAnda, 
   AndIncidProcJulg, 
   AndIncidProcExecJulg, 
   ProcConDist2005, 
   EmbExecDist2005, 
   ProcConDist2006MesAnt, 
   ProcConDist2006Julga, 
   ProcConDist2006Anda, 
   EmbaExec2006MesAnt, 
   EmbaExec2006Julga, 
   EmbaExec2006Anda, 
   MovProcConcPer, 
   MovProcConcl, 
   MovProcVistaMP, 
   MovProcCargaMP, 
   MovProcVistaPart, 
   MovProcOutTotal, 
   MovProcAudi, 
   MovProcCumpri, 
   MovProcDev, 
   MovProcPericia, 
   MovProcPubEdit, 
   MovProcProvEscriv, 
   MovProcSusp, 
   MovProcOutSitu, 
   MovProcArquiBaixa, 
   MovRecurInter, 
   MovRecurJulgAgravo, 
   MovRecurJulgapelacao, 
   MovRecurJulgtotal, 
   MovRecurProvAgravo, 
   MovRecurProvApelacao, 
   MovRecurProvTotal, 
   MovRecurInterFase, 
   MovRecurInterPend, 
   MovPrecNum, 
   MovPrecDataDist, 
   MovPrecDataUlt, 
   MovPrecDevTot, 
   MovPrecDevCit, 
   MovPrecDevOut, 
   RemTJMesAnt, 
   RemTJMesAtual, 
   RemTJDevolvTJ, 
   RemTJTotal, 
   RemOutTJMesAnt, 
   RemOutTJMesAtual, 
   RemOutTJDevolvTJ, 
   RemOutTJTotal, 
   RemOutComMesAnt, 
   RemOutComMesAtual, 
   RemOutComDevolvTJ, 
   RemOutComTotal, 
   RemRediOutMesAnt, 
   RemRediOutMesAtual, 
   RemRediOutDevolvTJ, 
   RemRediOutTotal, 
   RemOutrasInfo, 
   CustasProc, 
   CustasTaxaJudi, 
   CustasOutras, 
   AtosSentResMeritoTotal, 
   AtosSentResMeritoConhe, 
   AtosSentResMeritoCautelar, 
   AtosSentHomoTotal, 
   AtosSentHomoConhe, 
   AtosSentHomoCautelar, 
   AtosSentSemResolMeritoTotal, 
   AtosSentSemResolMeritoConhe, 
   AtosSentSemResolMeritoCautelar, 
   AtosMSentExecTotal, 
   AtosSentExecFiscal, 
   AtosMSentExecTitJud, 
   AtosMSentExecTitExt, 
   AtosDecisaoTotal, 
   AtosDecisaoLiminar, 
   AtosDecisaoOutras, 
   AtosDespProf, 
   AtosDespProfPlantao, 
   AtosAudRealizTotal, 
   AtosAudIntru, 
   AtosAudJulg, 
   AtosAudConcil, 
   AtosAudOutros, 
   AtosAudNRealiz, 
   AtosAudDesig, 
   AtosAcordoAudi, 
   AtosSentProfAudi, 
   AtosPesOuvAudi, 
   AtosDataAudiAfast, 
   AtosAutosConcSent, 
   AtosAutosConcPratica, 
   AtosAutosConcTotal, 
   AtosAutosConcSent100, 
   AtosAutosConcDiv100, 
   AtosDataConcAntiga, 
   AtosDecSusp, 
   AtosMandPriCivil, 
   AtosPresosCiveis, 
   AtosProcAntTramitNum, 
   AtosProcAntTramitData, 
   AtosProcAntTramitDUM, 
   AtosPrecAntTramitNum, 
   AtosPrecAntTramiData, 
   AtosPrecAntTramiDUM, 
   AtosPrecDevTotal, 
   AtosPrecDevCitacao, 
   AtosPrecDevOutras, 
   AtosInfTJ, 
   AtosOutrasAtividades, 
   Ferias, 
   MatSubstituicao, 
   MatAssinatura, 
   DataIniFerias, 
   DataFimFerias, 
   RemetOutraVara
  </code></pre>
  
  <p>FROM
  [Z:\QLIKVIEW\Todos os Mapas\Area Cível.xlsx]
  (ooxml, embedded labels, table is AreaCivil);</p>
  
  <p>This a full list of rows of 1 of 16 tables..  some hows are equal in each table and some are different.</p>