Assign filtering a variable

Hello!

I am trying to indicate a certain value in a variable that is equal to the value of a column in a CSV file.
Can i do it using a command like this?

Assign:
Var1 = table.select("[data] = d1")

Where d1, in the expression above, is the value of another variable?

Thanks!!

image

@Gustavo_Lopes What do you want to store in confData1 variable ?

1 Like

Hi @Gustavo_Lopes

If โ€œd1โ€ is variable and not the direct value and also if you are trying to achieve that the value in variable โ€œd1โ€ is present in the datatable having columnName as "data"

Then it can be done in following way :-

dt.Select("[data]='"+d1+"'")

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

2 Likes

Thanks a lot, Patrick. It solves my issue! :slight_smile:

@supermanPunch
iยดm trying to set a variable that is get in a txt file. Then i try to find that information in a csv file.

The answer from @Pratik_Wavhal solve my problem.

Thanks a lot for the support :slight_smile:

1 Like

Hi @Gustavo_Lopes

You are welcome :wink:

I have also learnt many more things from @supermanPunch :innocent: :raised_hands:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

2 Likes

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