Hello All,
I am trying to create a csv file with a specific format. A header record and some lines of data and a trailer record.
By using export datastore entity to csv smart service, I am able to generate the header record and the data required.
I need the trailer record in a specific format like "FORMAT,DATE,Number of lines in the file,....."
Is there any way to achieve this in Appian?
Regards,
Naveen
Discussion posts and replies are publicly visible
You could create a view that has the header, data, and then trailer in the proper order and then create a CDT so you can use the same node.
Hello Christine,
My header record is nothing but the column names and data is nothing but the data in the table. But my trailer record is dynamic and changes whenever i create the csv file.
For example if i create file today, my trailer record is TRAILER,20190905,500(no.of.recordsincsvfile)
Even if i create a view it will be only for the data but not for the trailer record.
So once i create the csv file.
How can i add the trailer record.
If the last row is the number of rows, why couldn’t you do a union in the view to add that data?
that's because if I add the data in the view and extract it the record will have same number of columns as my data which I do not need as I will be needing the trailer in just three columns as mentioned in previous comment
You can still do it and use null for the columns with nothing. I’ve used this approach many times. Especially when doing sub totals and grand totals.