Transpose CSV file (uncross a table)

Integrator.io
, ,
1

I have a csv that I am taking from an SFTP server and it has the following format

ID1, Column1, Column2, ..., ColumnN

ID2, Column1, Column2, ..., ColumnN

I need to send this to another SFTP server and instead of csv it has to be a .txt file which I figured out on the flow.

my problem though is that the structure has to be different as well and I don't know how to accomplish this, the expected output should be:

ID1, Column1

ID1, Column2

...

IDN, ColumnN

How can I achieve this?

If anyone has some insight it's greatly appreciated , thanks!

2

@leonelreyes I would put a preSave page script on your export FTP. For the most part, I used Celigo AI to write the script, but added a more description output requirement.

5301043caa20740200000001-3bfc3f5faef849e5a16d42492ac827c0.png
5301043caa20740200000001-3bfc3f5faef849e5a16d42492ac827c0.png2376×1161 94.8 KB

function preSavePage (options) {
  // sample code that simply passes on what has been exported
  let modifiedData = [];
  options.data.forEach(record => {
    Object.keys(record).forEach(key => {
      if (key !== 'Id') {
        modifiedData.push({ id: record['Id'], value: record[key], field: key });
      }
    });
  });
  
  return {
    data: modifiedData,
    errors: options.errors,
    abort: false,
    newErrorsAndRetryData: []
  };
}

Prompt:

my output should be an array of objects with 3 fields per object "id", "value", and "field" where id is the id, value is the value of the column field, and field is the key of the column field. I have a csv that I am taking from an SFTP server and it has the following format ID1, Column1, Column2, ..., ColumnN ID2, Column1, Column2, ..., ColumnN I need to send this to another SFTP server and instead of csv it has to be a .txt file which I figured out on the flow. my problem though is that the structure has to be different as well and I don't know how to accomplish this, the expected output should be: ID1, Column1 ID1, Column2 ... IDN, ColumnN How can I achieve this? If anyone has some insight it's greatly appreciated , thanks!