Right now, I am manually doing a lookup on the group category of the first data frame with the "group Audit " column on the second. Afterward doing a transpose on the audit variation based on the Group Type. Since I am new to UI Path Automation, is there any way to automate this process? This would save a lot of time. Suggestions are welcomed.
Thank you for responding .
I didn’t get your question regarding the color attributes.
I wanted to do a lookup on the group attributes from table 1 with Audit group in table 2 and afterward transpose the attributes corresponding to the Audit Group (Orange , Apple etc) as the headers.
Can yous share some sample input data (e.g. as Excel) and the corrsponding expected output with us? base on this we will workout a solution suggestion. Thanks for support
@Parvathy_Menon
Your output seems pretty same as input excel file… can you explain littlie deep after applying vloop how output should be(like second excel date where it is adding in first excel).
1.)First get the unique groups dt using below syntax
udt=yourDT.DefaultView.ToTable(true, “ColumnName”).copytodatatable
2.)loop udt and inside take filter data table activity to filter with audit dt and then you will get that particular group audit columns dt(auditdt)
3.)loop auditdt and inside use add data column to the original input dt.
