How to print output as a string

Help Studio
, , ,
1

Hi,

I have created a project which is as follow : image
The output of this project is coming in the form of vertical : image
But I want my output in the form of Horizontal like in picture i.e . as string : image

Can someone help me to do this?

Thanks in advance.

2

Also, My excel data is in the form of following type : image

Please help me to find out.

3

Hi @Sharma_Sania

Please try this

dtTable - your datatable
columnname - change as per your columnname

string.join(“,”,dtTable.asenumerable.select(function(d) d(“Columnname”).tostring).toarray)

image

image

image

4

Hi @prasath_S

Thank you for the reply. From where I have to apply this code? Can you please highlight the one in picture?

Thanks.

5

After read the data from excel you can use log message and check if its coming correct…thanks

6

Also, I want to print my data in output, not in message box.

Thanks.

7

use can use writeline or logmessage instead of message box

8

I am exporting the data from excel. Is it possible to run those steps which you mentioned above?

Thanks.

9

yes instead of build datatable use read range activity and store the data in datatable(assume dtTable)

10

I already used read range activity and stored data in dt (as you mentioned). I inserted output data table to convert it in string but I’m still unable to get the desired output.

11

can you show the workflow screen shots please…

12

Can you please check my original post.

image
image841Ă—518 15.9 KB

13

what is the datatable variable name and column name in excel

14

image
image488Ă—715 15.2 KB

15

Try this

read range output should be dtTable

string.join(“,”,dtTable.asenumerable.select(function(d) d(0).tostring).toarray)

16

I used read range output as dtTable but still the same error.
string.join(“,”,dtTable.asenumerable.select(function(d) d(0).tostring).toarray)- Where I have to use this logic?

17

what error you are getting.

  1. Use read range and store the data in datatable (Variable name dtTable)
  2. use log mesaage and write the syntax
18

image
image886Ă—300 11.4 KB

I have already done the concept which you mentioned for read range. But still my output is coming in the form of vertical. image

19

Dont use output datatable instead use the syntax i gave in Logmessage

string.join(“,”,dtTable.asenumerable.select(function(d) d(0).tostring).toarray)

20

I want my output in the form of this one image