How to convert data table to tabular format & paste tabular format in send message text

Help Studio
, ,
1

I have input in dt1.Used output datatable & got output in string format like this
id source name status
1 s1 sri yes
8 s3 riya no
4 s5 ramu yes
I want this in tabular view to send in message chat
Please help

2

@vnsatyasunil,

Convert that datatable to a html table and use that to send in the mailbody with HTML Body enabled.

3

can you please guide how to convert datatable to html table
after that we need to add html table to message in webex

4

@vnsatyasunil,

Try with this

DataTableToHtmlText.xaml (12.6 KB)

5

In webex chat message if I give this html string output variable message delivering as string text but I need table view of that like columns & rows. How can we achieve that?

6

not html text I need that text in table view
from output datatable we get like this below

s.no,name,id,status
s2,sri,5,yes
s5,suma,9,no
s8,riya,4,yes
if mail means we get table format but I want to send in chat of webex

I want to remove commas & need to view like this
s.no name id status
s2 sri 5 yes
s5 suma 9 no
s8 riya 4 yes
please help

7

Hi @vnsatyasunil

You can create a data table by using Generate Data Table activity and by giving below mentioned details create a data table and store it in a variable and pass the variable.
Pass the input file or data into input field and save the result into a variable.

image

image
image1108×789 27.5 KB

Hope it works !!

8

datatable output is fine but need to paste like this in webex chat
table

9

Hi @vnsatyasunil

can you please share the activities you are using for WebEx because I don’t have any account in WebEx to connect and check

Regards.

10

scope
grp
In message text I need to pass that datatable in table format

11

Hi @vnsatyasunil

Can you send me the text you wrote in Text In field.

Regards

12

text is
“Hi,Please check below”+Environment.newline+“”+outDT.tostring+“”+Environment.newline+“for more details check file”

In place of outdt.tostring that table view should display

13

Isn’t it printing the data table when you are executing the code?

14

only string variables are accepted in text message we have output in data table type. From output data table I got string output but it is separated with commas Instead of that I need to view that string data in table format

16

Is there any other way please help?