Based on two conditions it has to write values on A cell

Help Something Else
#1

if the value starts with D then it has to write snapdeal on the A cell under the platform… in else condition it has to write olx on the A cell like what ever the value will come.

one more thing to mention B cell values can extend

attached pics for reference
excel 2 doubt
excel 2 pt2 doubt

Forum Engagement Daily Reports
#2

Read the excel into datatable then do a for each row of the datatable.
If row(“id”).ToString.ToLowerInvariant.Substring(0,1) = “d” Then
assign row(“Platform”) = “snapdeal”
Else
assign row(“Platform”) = “olx”

After all rows has been processed write the datatable to excel by using write range

1 Like
#3

for each row

if – row(“id”).tostring.tolower.startswith(“d”)

then – assign - row(“platform”)= “snapdeal”
else – assign- row(“platform”)= “olx”

1 Like
#4

Hello @sathish_Kumar6,

Read the excel contents into a datatable.

For Each Row in datatable
if
row(“id”).ToString.Substring(0,1) = “D”
Assign
row(“Platform”) = “snapdeal”
else
Assign
Row(“Platform”) = “olx”

After for Each Row ends write out excel back to original sheet

Best,

1 Like
#5

may i know to implement assign in my workflow?

#6

may i know how to implement assign in my workflow?

#7

how to implement assign bro?

#8

assign
assign1308×328 14.8 KB

1 Like
#9

thanks bro

#10

Use the assign activity

#11

bro i tried but cant do it … cuz i cant understand where exactly output will store… so can u send me the workflow when u have some time

#12

Valiadtion_based_2columns.xaml (8.5 KB)

1 Like
Forum Engagement Daily Reports
#13

thank u so much bro for the workflow… but value for a required activity argument ‘values’ was not supplied. like this error shows bro.

#14

like this bro
error

#15

you have to create the var or argument

i just created for format , like that way you have to modify your self

#16

sorry for asking too much bro… may i know where i have to create var bro… i think i have created a workflow like youself even added read range value op Dt in my for each but it stiill shows the error

#17

send your workflow

1 Like
#18

bro when i try to create a new workflow for you… it successfully ran… so much thanks bro… for your patience really thanks.

#19

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.