https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506161#M14594 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/42759">@francesco_menin</a>&nbsp;</P> <P>I have seen this, I just use the "generate Numbered columns" and then rename these in the script.&nbsp;</P> <P>Regards Jandre</P> Mon, 17 Feb 2025 11:42:09 GMT JandreKillianRIC 2025-02-17T11:42:09Z https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506144#M14593 <P>Hi,<BR />I'm looking to understand an error message that is showing since a couple of weeks when loading data from a Worksheet:&nbsp;<SPAN>a column named "xxx" already belongs to this DataTable.</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="francesco_menin_1-1739787986396.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/177615i06C48A8B6D095542/image-size/medium?v=v2&amp;px=400" role="button" title="francesco_menin_1-1739787986396.png" alt="francesco_menin_1-1739787986396.png" /></span></P> <P>We don't actually have two columns with the same name or anything like that.</P> <P>Has anybody a suggestion on this?</P> <P>Thanks!</P> <P>&nbsp;</P> Mon, 17 Feb 2025 10:30:31 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506144#M14593 francesco_menin 2025-02-17T10:30:31Z https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506161#M14594 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/42759">@francesco_menin</a>&nbsp;</P> <P>I have seen this, I just use the "generate Numbered columns" and then rename these in the script.&nbsp;</P> <P>Regards Jandre</P> Mon, 17 Feb 2025 11:42:09 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506161#M14594 JandreKillianRIC 2025-02-17T11:42:09Z https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506165#M14595 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/42759">@francesco_menin</a>&nbsp;Conseguiu checar alguma coluna após as colunas utilizadas? Nos testes que fiz aqui, este erro é apresentado quando existem duas colunas com o mesmo nome. Além disso, pode habilitar a flag GENERATE NUMBERED COLUMNS para evitar  este problema, porém as colunas precisam estar no mesmo local para evitar atualizações futuras.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura de Tela 2025-02-17 às 09.37.49.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/177622i4D48ED7FE7AFBC10/image-size/medium?v=v2&amp;px=400" role="button" title="Captura de Tela 2025-02-17 às 09.37.49.png" alt="Captura de Tela 2025-02-17 às 09.37.49.png" /></span></P> <P><BR /><BR /></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Captura de Tela 2025-02-17 às 09.36.22.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/177621i15E9417C1463788D/image-size/medium?v=v2&amp;px=400" role="button" title="Captura de Tela 2025-02-17 às 09.36.22.png" alt="Captura de Tela 2025-02-17 às 09.36.22.png" /></span></P> Mon, 17 Feb 2025 12:38:03 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506165#M14595 BrandonFontes 2025-02-17T12:38:03Z https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506171#M14596 <P>That does solve it, though I don't get the why <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P> Mon, 17 Feb 2025 13:11:01 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506171#M14596 francesco_menin 2025-02-17T13:11:01Z https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506174#M14597 <P>Peço desculpa para os erros, mas nao tenho um teclado portugues <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P> <P>Aparentemente, nao vejo duas colunas com o mesmo nome e tambem a "preview" nao ajuda em isso.</P> <P>No entanto, a resposta està certa e consigo resolver assim. Avisei o cliente.</P> Mon, 17 Feb 2025 13:16:32 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506174#M14597 francesco_menin 2025-02-17T13:16:32Z https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506176#M14598 <P>Sem problemas&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/42759">@francesco_menin</a>&nbsp;hehe<BR />Tenta carregar a tabela com a FLAG ativada, isso vai fazer com que os títulos das colunas virem linhas, e ai será possível verificar o problema também</P> Mon, 17 Feb 2025 13:20:06 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Cloud-Google-Drive-amp-Spreadsheets-Error-in-GetWorksheetV2/m-p/2506176#M14598 BrandonFontes 2025-02-17T13:20:06Z