Export CDT to Excel Smart Service Vertical Data insertion

Hi ,
you can achieve it by creating a new CDT which will hold the resultset ( your actual CDT which hold the data as single row) under a single field (make it as an array) and mapped that as only one column in excel smart service , than it will pull all your result set in a single column.

I think you req to generate cell keys and cell values accordingly to get the desired output.

Hey Manish,

What if we need something opposite? I have a CDT from which I just need to fetch only one columns data in horizontal direction i.e from left to right. How can I achieve this functionality? Thanks in advance

Hi Manish,

This approach didn't work for us. We are getting an error as

 

Have you created a CDT or Datasubset?

CDT with one text field which is an array type. and the CDT is also an array.

So how exactly your are passing the values in smart service for cdt column?

In place of pv!CDT.data you have to pass the value like ="data"

This error that I have attached I am getting this in "Cell_values" input column and not "Cdt_field_to_export", so I can't pass the value as ="data"