Match column and update after concating to another column

Help Studio
, ,
25

Hi @Shilpa_Mohanty ,

If you could help us by providing the Expected Output Data for the Input data provided it would help us to define proper logic and provide you the solution in the earliest.

26

Sample2.xlsx (13.1 KB)
this excel and same i used your logic

27

Sample2.xlsx (13.1 KB)
sample input
output -
if badge# match in both sheets, concat badge #- badge field2 + badge field4 from sheet 1and paste in badge # column of sheet 1

28

Kindly refer to this, it is working for me.

Forum_ExcelConCatenate.zip (104.1 KB)

image

image
image698×403 13.9 KB

29

@Shilpa_Mohanty ,
Let us confirm on the Output data, Screenshots are provided, Let us know if this is the Requirement :
Sheet 1 : (Taking a very small dataset, one row marked in Yellow)

image
image697×90 4.21 KB

Sheet 2 :
image

The Output According to your Statement :
image

Is the above Output Statement true for your requirement ?

Let us know what is your thoughts on this.

30

output should be in Sheet2 of column Badge #

31

is there any way to work with single lookup datatable instead of 2

32

@Shilpa_Mohanty
For two different columns, need 2 lookup data tables.
What issue are you facing? Why you don’t need 2 lookups?

33

@Shilpa_Mohanty

Here is the alternative flow without lookup. Where nested loop used in it
Forum_ExcelConCatenate.zip (131.5 KB)

34

Excel_ColumnUpdate.xaml (46.0 KB)
i wanted to use this approach
but in the next sheet, its writing all columns from sheet1
where as i want to update only column badge # in sheet 2

35

@Shilpa_Mohanty
Check the alternative method 2 flow
Forum_ExcelConCatenate.zip (159.0 KB)

And your flow refers to that, you look up to sheet 2 but update the values in Sheet1

Kindly refer to the flow above I send

36

@Shilpa_Mohanty ,

Alternately, for a simpler operation like match and concatenating we can also check by first making a match (Join Datatables Activity) and then use DataColumn Expression property to update the values of the Required Column.

But in this method, column names change according to the expression used, hence we change the column names back to the original one by storing their indexes.

Check the below Workflow :
DT_MatchColumnAndUpdate.zip (13.2 KB)

If the cases cannot be handled using DataColumn Expression, then we use For Each Row Loop method itself for performing update operations.

37

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