Hello All,
I'm using Export cdt to excel smart service for creating an excel file based on the data we have in our CDT. The problem here is I need the data from one column only and due to that its displayed in vertical format but I need it to be horizontally aligned. Can someone please let me know the best way to do this?
eg: Currently data in excel displayed like below
abc
pqr
xyz
but i need it like
abc pqr xyz
Discussion posts and replies are publicly visible
Hi viveku0001, You can try it by giving Cell_keys and Cell_values in the 'Export CDT To Excel' smart service. For example,Cell_keys:{A1,B1,C1}Cell_values:{"abc","pqr","xyz"} or cdt.columnname but for this you have to know how many elements your cdt column has and accordingly set you 'Cell_keys' array.