Error in Write Range Activity

Help Studio
, ,
1

Hello,

I have a condition where I need to check if in_TransactionNumber =1

it will write the data into excel . I am using write range activity .

image
image1326×1056 120 KB

If its not transaction number 1 , it will keep appending the rows and writing the next set of data in excel.
image
image1326×1056 120 KB

However I had two Datas in my input file but I am getting the same data in both the rows in out put excel file.

image
image3312×218 185 KB

I should get two different data rows in my output file but I am getting the same data twice in my output file

image
image1620×122 7.69 KB

2

@marina.dutta

Can you please show how are you adding…

Looks like you adding the same row always

Cheers

3

Hi @marina.dutta ,

We see that the screenshots shared are identical, is it that the same is being done in the else part as well or was a mistake when performed copy paste here ?

Also, we do not see the Transaction Number condition.

4

Hi @marina.dutta ,

Could you please attached more information here. Screenshot are same.

5

@Anil_G

please find the attachment.
BlankProcess1.zip (3.5 KB)

6

@supermanPunch

please find the attachment.
BlankProcess1.zip (3.5 KB)

7

@supermanPunch

The condition is
I have three different types of Transaction:

  1. New Business ,Upsell ,Renewal.

If the first Transaction is of Type Newbusiness, next time whenever the data is of type New Business , it should just go and append the data in excel sheet. Similarly , if the first transaction is of type Renewal it should write the data in excel and next time whenever the type of transaction is Upsell , it should go and append the data in the respective upsell excel sheet.

8

@Anil_G

If the first Transaction is of Type Newbusiness, next time whenever the data is of type New Business , it should just go and append the data in excel sheet. Similarly , if the first transaction is of type Renewal it should write the data in excel and next time whenever the type of transaction is Upsell , it should go and append the data in the respective upsell excel sheet.

9

@marina.dutta ,

Check the below modified workflow :
BlankProcess1 (2).zip (3.6 KB)

I have changed the design with Switch and using 3 variables to store the count of the three types, as the Transaction Number could not be used for determining all the transaction numbers for all three types.

Firstly , check if you are able to understand the flow/design and then test it with the actual values.

Edit: Updated the workflow for the Write and Append Range part with Switch activity as well.

11

@supermanPunch

Getting Object reference error. All variables are declared still getting the error.

image
image1420×468 114 KB

12

@marina.dutta ,

Looks like the dictionary is null, Could you check how the value is assigned or passed to it.

There is a variable created by me with the same name, if it needs to be an argument, you can delete the variable and check.

Note, we have shared the idea and logic, if it is being integrated into a larger workfow the changes need to be done accordingly.

13

@supermanPunch

The thing is for first Transaction it should go to Then part. In my case its going to else part . That means the condition newBusiness=1 OrElse upSell=1 OrElse renewal=1 is not satisfying ?but ideally for the first time it should go to Then part

15

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