CSV Formatting Challenge

[spencerstone]

Hey all - I need to compose a CSV in Workato that I am not sure is possible, here is my criteria (screenshot below): 

Row 1 has to be as follows: EmployeeManagerImport,,,,,,

Row 2 has to be as follows:  H,EmployeeManager,EmployeeManager,EmployeeXRefCode,ManagerXRefCode,EffectiveStart,EffectiveEnd

Row 3 has to be as follows: D,EmployeeManager,EmployeeManager,{dataPillValue},{dataPillValue},{dataPillValue},{dataPillValue}

As you can imagine, row 1 is really where issues are being caused. Row 2 is effectively the header row, however I need the value in A1 and the subsequent blank cells in order to tell the system what action to perform. 

Has anyone else run into a similar custom CSV formatting challenge like this? 

#automation #hrTech #SFTP

[gary1]

Assuming you can make the CSV for rows 2 and onward without issue, all you need to do is add the header row -- like, literally "text add" the row to the beginning of the CSV. 

• Action 1 - Make your CSV using a CSV action or however you want. The output should be a data pill of text
• Action 2 - Make a logger action, switch to formula mode, and do this:

"EmployeeManagerImport,,,,,,\n" + [CSV data pill]

The "\n" is just a line break so it doesn't merge with row 2.

I just tested this and it works.