Map excel into key value pairs

[NVolanovsky1595338020]

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

[manodwhb]

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