Attend String to Excel Datatable

Hi,

I read all values ​​from “dbOutputText” (DataTable) from a column using an Excel read list. However, I would now like to write for each value read out or a string in front of it. Is there a way to do that?

Hi @Crusha ,

Use for each row and inside body use row(“column name”).tostring to get each value.

Thanks and Regards,
Krishna

1 Like

Here my .xaml

I would after Read Range insert a string or a word into the datatable.

StringTest.xaml (7 KB)

Check this updated workflow, @Crusha
StringTest.xaml (6.7 KB)

1 Like

You want to add data (datarow) into datatable?

Yes, but I don’t want to change the data in the Excel list.

You want to update any column?

If you want to add new data row into datatable then use add datarow activity
Give parameters like datatable name and then add data using array or datarow
so it will add new data row in your datatable

1 Like

Yes, but when I try to add a string to a datatable it always throws a compiler error processing expression.

can you share your file so i can check

Sure.

I have in “outputNumber” only a number, for example “1”. This number should be displayed before each value in the datatable “dbTableText”. For example: “1 this a text” → “outputNumber dbTableText”.

Thank you!

StringTest.xaml (7.1 KB)

@Crusha How many Columns Do you have in your Excel File?

only 8 values ​​but these values ​​can be expanded dynamically

@Crusha Is this the Format you needed it to be ?
Capture

My excel list has this format:

grafik

I read the column 1 or 2 or 3 and output these values. I would like to add the 1 or 2 or 3 to these values ​​before the values. “1 amet” or “3 faucibus” etc

@Crusha Can you Share a ScreensShot of how do you Expect the Output to be ? It will give us a Clear Idea what Should be Done :sweat_smile:

my current output looks like this in a dropdown menu when i choose the number 1

grafik

And I want the numbers I select to be included in the text. For example:

grafik

@Crusha Ok, It means you just need to Update the Values in the rows.

Ok if that works. :smiley: I have tried several variants, but unfortunately I have not been able to do it

@Crusha Depending on the Requirement, I have made a Sample Workflow, Please Check and Notify it is not as Expected :
StringTest.zip (9.7 KB)