How to append data from two different columns in an excel and write it in an existing column

Help
,
1

How to append data from two different columns in an excel and write it in an existing blank column?

I have downloaded an ExcelSheet from SAP and processed it further. The current state is as follows:

excel

where the First column only have the columnName (LIFNRERNAM) and I need to append the data from the 4th column (columnName: LIFNR) and 3rd column (columnName: ERNAM) and set it as the content of the first column (columnName: LIFNRERNAM)

Can someone help me out with an approach?

PS: In one of the previous steps I have added the blank column setting the columnNames appending 2 other columnNames

2
  1. Concatenate the column 3rd and 4th in loop, like result = str1.concat(str2)
  2. Write Range from say column A2

Let me know if you need more help.

3

TestDate.xaml (7.3 KB)
Please find the attached XAML.
I think this will solve your problem

4

Thanks @parasmanichauhan I have to do that exactly. Should I create a new DataTable through OutputDataTable and then process the strings?

5

You can do this it in even more easier way…

  1. Excel application scope (mention your full file path)
  2. Read range inside excel application scope and in output property mention datatable variable name in which you want the values and then process them.
6

@parasmanichauhan [quote=“parasmanichauhan, post:5, topic:160100”]
Read range inside excel application scope and in output property mention datatable variable name in which you want the values
[/quote]

Yes, I am done till this. I am stuck with the approach to process.

7

@debanjan - are you getting any error? Can you please share?

8

Also, one quick question you only want fill data in col1 and then process it or you are getting some inputs for col3 and col4 (from within the process) and then you want to fill data in col1 and then process it?