Map data?

Help Activities
, ,
1

Hello. I want to map data and get value column in Feedback_Recommendation

I have 2 file (input and master)

i want tot check as below.

  • column S_Catagory (file input) with column Category (file master Sheet1)
  • column S_Sub Catagory (file input) with column Sub Catagory(file master Sheet1)

image
image827×212 16.7 KB

If match get value in column feedback_Recommendation
else not match check next sheet
i want tot check as below.

  • column S_Catagory (file input) with column Category (file master Sheet2)
  • column S_Sub Catagory (file input) with column Sub Catagory(file master Sheet2)
  • column Issue (file input) with column Issue(file master Sheet2)

image
image960×215 16.4 KB

If match get value in column feedback_Recommendation
else get value = not found.

Please guide me about it.

Thank you.

input.xlsx (8.1 KB)
Master.xlsx (11.8 KB)

2

@fairymemay

read all the 3 excels into 3 datatable dt1,dt2,dt3

now use invoke code activity with dt1 as in/out argument and dt2 and dt3 as input arguments

dt1.AsEnumerable.ToList.ForEach(sub(r) r("Detail") = If(dt2.AsEnumerable.Any(function(x) x("Category").ToString.Equals(r("S_Category").ToString) AndAlso x("Sub-Category").ToString.Equals(r("S_Sub Category").ToString),dt2.AsEnumerable.First(function(x) x("Category").ToString.Equals(r("S_Category").ToString) AndAlso x("Sub-Category").ToString.Equals(r("S_Sub Category").ToString))("Feedback Recommendation").ToString,If(dt3.AsEnumerable.Any(function(x) x("Category").ToString.Equals(r("S_Category").ToString) AndAlso x("Sub-Category").ToString.Equals(r("S_Sub Category").ToString),dt3.AsEnumerable.First(function(x) x("Category").ToString.Equals(r("S_Category").ToString) AndAlso x("Sub-Category").ToString.Equals(r("S_Sub Category").ToString))("Feedback Recommendation").ToString,"Not Found")))

cheers

3

@Anil_G error as below.

image
image980×153 10.7 KB

But I want output by row not all row.
Example

round1 row1 output = test4
round2 row2 output = Not Found

4

Can someone guide me for solve it.

Thank you…

5

Check this, I have provided xaml file:-

Thanks

1 Like
Forum Engagement Daily Reports
6

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