create a csv table with multi row header

Like (0) Share

Report

Posted on 5 Dec 2020 18:40:18 by sandracosta

Hello,

I need to create a csv table which has a specific format / template with a 3 row header, for each column (like shown above).

StartDate	Status	Call_SID	Interaction_ID
Start Date	Response Type	Call_SID	Interaction_ID
{"ImportId":"startDate","timeZone":"Europe/London"}	{"ImportId":"status"}	{"ImportId":"Call_SID"}	{"ImportId":"Interaction_ID"}
«values»	«values»	«values»	«values»

This is a specific format we use to import legacy data.

The first three rows are considered header for my platform. As the values are only expected in the 4th row of the file.

I have managed to create the csv all right with the right data in the value cells. All except for the header that I can't manage to have in 3 different rows / cells (all I could manage was to have all strings in the same cell).

Can you please advise on a way to achieve this?

All responses (4)

Answers (1)

Verified answer

fchopo 7,968 Super User 2025 Season 1 on 07 Dec 2020 at 20:14:58

Like (1)

Report

Re: create a csv table with multi row header

Hello @sandracosta

I did a test on my side that it is working:

In this example, we have an excel file with 2 columns (Region, Country). The steps are:

1) Define headers (3 rows)

2) List Excel Rows

3) Select the Region and Country columns

4) Create a CSV table

5) Replace "Region,Country" string by the headers.

Hope it helps!

Ferran