why am unable to run the loop here.
@taruna.mehra Have you initialized VarDt? What is the value of VarDt at the time of debugging.
check varcounter and varDT have values or not or initialized or not
Hi there @taruna.mehra,
I hope you are well!
As @Sreelatha278 notes above, your DataTable is likely not initialised at this point during execution.
You should be able to work around this by evaluating it during the condition, for example:
IsNothing(VarDT) OrElse VarCounter <= VarDt.Rows.Count
This will check whether VarDT is initialised, prior to evaluate the Rows it has.
Depending on your specific use-case, you will likely need to tweak the above.
Also, if you are unfamiliar with AndAlso/OrElse, this post is excellent:
Difference between “And” and “AndAlso” , “Or” and “OrElse” - Learn - UiPath Community Forum
Please let me know if you have any further questions.
Thanks once again for your support,
Josh
Hi @Mr_JDavey i tried this and it worked.
could you pls help me why i am not able to pass the data to get transaction? i am sharing my below screen shot of my IntAll settings screen shot along with arguments.
Hi there @taruna.mehra,
Fantastic, glad it worked!
Is OutDT
the DataTable we are using in your original condition?
If so, it has a Direction of In
, but it should be Out
- Assuming it is being populated within InitAllSettings
and you want to “pass” that data out of this flow, allowing you to access it elsewhere.
Please let me know your thoughts.
Thanks once again,
Josh
Hi, Have corrected the same and connected it with VarDT but still not working. Its showing below output
Hi again @taruna.mehra,
Is OutDT
being populated within the InitAllSettings
Workflow?
What is the DataTable
you are trying to extract/iterate through for processing?
Thanks once again for your support,
Josh
Hi Below is the config file screen shot. i need to guide robot that this is the filepath and file name so he will take that data file from that file path given
Hi there @taruna.mehra,
Understood - In that case, you will need to use the Excel/Workbook
Activities to extract the data to populate the DataTable
.
If you put the below activity after your InitAllSettings
Invoke within the Init
State:
Where the Path.Combine
code is:
Path.Combine(config("FilePath").ToString, config("FileName").ToString)
And set your Output DataTable
as VarDT
:
You should have a populated DataTable
to iterate through and process.
Please let me know your thoughts.
Thanks once again,
Josh
thanks… what i did i pass the data in In_config variabel and connected it with Config as out Config data is passing data to config. then i tried as below…
same way when am passing the data in IntAllApplication then its working fine. see below screen shot.
Hi there @taruna.mehra,
Hmmmm, are you able to share your workflow files as a ZIP?
I can take a look and try to root-cause the issue.
Thanks once again,
Josh
Please connect with me on zoom call then we can sort it out
Please message me your email id.
Hi there @taruna.mehra,
Apologies, got a little distracted.
Can you take a look at this:
NSE EXAMPLE.zip (976.2 KB)
I have added the ReadRange
within the First Run
section of the Init
State - There is also a log, so we can evaluate whether it reads the correct file.
Finally, I noticed you were using String
Variables for True/False values - I would recommend using Booleans
for these and have amended them, I hope that is okay!
Please give this a run and let me know the output.
Thanks once again,
Josh
Hi Below is the output but its not selecting as per given data file.
strangly its reading the URL correctly but not the balance data
Hi there @taruna.mehra,
Apologies, I see the issue!
If you go into the transition from Get Transaction Data
to End Process
and Get Transaction Data
to Process Transaction
, these are still using the TransactionItem
:
If you double click the transitions:
You will need to edit No Data
to be VarDecision = True
and New Transaction
to be VarDecision = False
.
Example is here - This one is tested:
NSE EXAMPLE.zip (976.1 KB)
Please let me know your thoughts.
Thanks once again,
Josh
Check whether VarDT has been initialized or not?
Thanks now its reading the file. i just want to know why its not scrapping the data. i added message box after correcting the selector but output in message box was blank. Could you pls help me by connecting on zoom call or microsoft meet?