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
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
for each row
if – row(“id”).tostring.tolower.startswith(“d”)
then – assign - row(“platform”)= “snapdeal”
else – assign- row(“platform”)= “olx”
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,
may i know to implement assign in my workflow?
may i know how to implement assign in my workflow?
how to implement assign bro?
thanks bro
Use the assign activity
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
thank u so much bro for the workflow… but value for a required activity argument ‘values’ was not supplied. like this error shows bro.
like this bro
you have to create the var or argument
i just created for format , like that way you have to modify your self
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
send your workflow
bro when i try to create a new workflow for you… it successfully ran… so much thanks bro… for your patience really thanks.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
