Google Sheets columns with the same name

[Matthew Pryor]

Hi

Is there a way to map variable names for use in subsequent steps when a Google Sheet has more than one column of the same name?

I understand it would be preferable to just rename the column, but there are reasons that is not ideal.

To be clear, say I have a sheet with 6 columns, being primary and secondary contact details - if the 6 columns are A,B,C,D,E,F and the header names are firstName,lastName,email,firstName,lastName,email - it seems I can't refer to those columns by the auto generated variable names in a Google Document/PDF generation tasks - the values are blank.

If I rename the columns, the generation works - so it seems like the duplicate column names are causing an issue.

Is there some way to control the mapping of variable name to column name?

Thanks
Matthew

[Daniel Florey]

Hi Matthew,

you are right,. there is currently no way to control the column names if you have multiple columns with the same header.

You can specify a different row as headers, so probably you have a subsequent row in your case that has unique and stable info in it to be used as column names?

You could also use the low-level Sheets API (in the more section), which provides access to a given range of cells, but is more tedious to use.

I'll look into our end to check if we can add unique column names by appending a suffix to duplicate columns and will let you know-

Hope this helps,

Daniel

--
You received this message because you are subscribed to the Google Groups "Ultradox" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ultradox+u...@floreysoft.net.
To view this discussion on the web, visit https://groups.google.com/a/floreysoft.net/d/msgid/ultradox/0a87e3c0-8ac8-4919-a45d-6d324cb22fabn%40floreysoft.net.

--

Kind regards,

Daniel Florey

floreysoft GmbH

Telemannstraße 22, 20255 Hamburg, Germany

Sitz der Gesellschaft: Hamburg

Amtsgericht Hamburg

HRB 106613 

Geschäftsführer: Daniel Florey

[Matthew Pryor]

thanks Daniel - we will take a look

--

Matthew Pryor Co-Founder & Managing Partner Tenacious Ventures j...@tenacious.ventures +61 4 0710 2200 tenacious.ventures

Tenacious Ventures Management Pty Ltd, Corporate Authorised Representative (CAR 001275760) of Sandford Capital Pty Ltd (AFSL 461981) The content of this email is confidential and intended for the recipient specified in message only. It is strictly forbidden to share any part of this message with any third party, without a written consent of the sender. If you received this message by mistake, please reply to this message and follow with its deletion, so that we can ensure such a mistake does not occur in the future.

[Daniel Florey]

The issue with multiple columns with the same header should be fixed. Please click on the refresh icon in the "Load row(s)" or "Load worksheet" building block and configure the column names in the dialog box accordingly.

Please let me know if this works for you.