Column selection based on data

[MrKezay (Alperen KEZAY)]

Hello everyone,

According to the “mudur” and “uzman” data from the top table, I need to select the “mudur” or “uzman” columns in the bottom table. How can I do that?

Thanks!

[Srini84 (Srinivas)]

@MrKezay

You can use Join Datatables activity for this

Use Read Range for 1st excel file and 2nd excel file after that use Join Datatables activity and as the condition 1st excel file “Company” = “Sirketismi”

taking company is the constant value in the both excels

Hope this may help you

Thanks

[MrKezay (Alperen KEZAY)]

@Srini84 I did this without any problems. What I want to do is to select the column in the second excel according to the “mudur” and “uzman” data from the “Title” field.

[Srini84 (Srinivas)]

@MrKezay

Is it this you are trying?

Hope this may help you

Thanks

[MrKezay (Alperen KEZAY)]

@Srini84 I can’t believe. Sorry, I thought too deeply. Thank you so much

[Srini84 (Srinivas)]

@MrKezay

No worries, I’m glad that I helped you to resolve your issue
Happy learnings

Thanks