Map excel into key value pairs

NVolanovsky1595338020 — Thu, 08 May 2025 17:40:29 GMT

Hi all,

i try to convert excel into key value pair when the key is the cell reference (B14 for example) and value is a numeric value. So i expect the excel to convert to file delimeted looking like this B14:200000.

or alterenatively, if possible somehow map a key based on column name and row name with a value for example colname^rowname:val

thank you,

Nadia

Re: Map excel into key value pairs

manodwhb — Mon, 27 Jul 2020 04:41:46 GMT

@Nadia Volanovsky , you can convert using tUnpivot component ,which is custom component.

topic Re: Map excel into key value pairs in Archived Discussions

Map excel into key value pairs

Re: Map excel into key value pairs