Match column and update after concating to another column

Match “Made #” in both worksheets.(Sheet1 and Sheet2)
If “Made #” is matched
Concatenate Made #, Made Field 2, Made Field 4
Format: Made# - Made Field 2 Made Field 4
Replace “Made #” value in Sheet1 worksheet.
Lookup the Made# from Sales worksheet to return “Made# - Made Field 2 Made Field 4” value.

Hello @Shilpa_Mohanty
Kindly provide us with some sample input and clarify ur expected Output. It helps us to provide better solutions for you.

Sample.xlsx (10.3 KB)
If made # in both sheets match, then we need to concatenate Made #, Made Field 2, Made Field 4 from Sheet1 and update in Sheet1 for Made #

@Shilpa_Mohanty
Kindly find the Xaml file, It may help you
Forum_ExcelConCatenate.zip (86.7 KB)
Output :point_down:

if i print(row(made #)), its printing
but when i use write range to write that data table, its not printing anything in excel

Kindly share your Flow or screenshot.
and

Is the output was expected?

i need to write in Sheet 2 made # column but its not working

It means you need to update made# in sheet2

Kindly show some screenshots of what you need to output.

yes i need to update in Sheet2 made # column after concatinating values from sheet1
I have just updated 2 rows
Sample.xlsx (10.4 KB)

Hello @Shilpa_Mohanty

I think you can use Vlookup activity in uipath.

Thanks

@Shilpa_Mohanty
Kindly refer to the Xaml file :point_down:
Forum_ExcelConCatenate.zip (89.8 KB)

Output

Above shown output was expected?

if made field 2 or made field 4 is empty, then we dont have to append only 1 of the field, we have to log a message

From my understandings

  • 1st need to check the Made# values in both sheets.
  • If matched, need to join the values of Made#+Made 2+ Made 4
  • Also check is there are any empty fields in Made2 and made, If anyone has an empty, don’t need to Join the values and generate the log messages .

Is it correct?

Refer to this screenshot, is excepting output?

in both worksheet we have to check if made # values are matcing
if matching- concat from sheet1(only if other 2 fields have values) and update in sheet 2
if either 1 is not matching(made # not matching - log message) & if made field 2/4 is empty- then also log message

@Shilpa_Mohanty
Check this one. Verify the process and let me know if there are any changes.
Forum_ExcelConCatenate.zip (90.0 KB)
Output


image

i tried doing write to CSV(as they changed the type to .csv)
I read the csv also but while writing, its getting problem
but only 1 sheet remained and other disappeared

@Shilpa_Mohanty
If your query related to lookup and concatenate was solved, then kindly close the topic by marking the solution. It helps someone who looking for the same issues.

For another topic you should create another topic and ask your questions.

From my knowledge. CSV format doesn’t have sheets. So you should write sheet1 and sheet2 in different 2 file of CSV

no concat is not happening as expected
as at one place its concatinating thrice
image

Kindly share your flow or screen shot.
also refer the xaml file :point_down:

You can use this query to check value exist in column or not

DataTableName.AsEnumerable().Any(Function(x) x(“ColumnName”).ToString = row(“YourString”).ToString)