Problem about --use activity 'Read Range' read excel

Help
,
1

I use activity ‘Read Range’ read excel,but my excel have the same colum,I also want to choose the property ‘Add heads’. How can I solve it?

thanks!

2

for example :there are three column:
column1: A,1,2,3
colunm2:A,1,2,3
column3:B,6,6,6

I want to get the dataTable with: A,1,2,3 and B,6,6,6

thank you very much

3

@jmy Check attached file

ExlExample.zip (12.1 KB)

4

sorry
not like this

5

image
this is the material

I want to use the “read range” output a datable like this:
image

6

in read range specify the rage eg. B1:D5

Please refer the attachment.Read Excel data.zip (7.7 KB)

7

@jmy You needs to remove duplicate column?

8

@jmy I am attaching a workflow that performs the activity specified by you.

RemoveDuplicateCols.zip (9.3 KB)

Please let me know if you have any queries

2 Likes
9

Hi @nivedita,
I tested your project . But out put is different.

Input excel sheet

image

OutPut…

image

Regards
Balamurugan.S

10

@balupad14 I tried to replicate your test case but my output is

image
image629×787 18.1 KB

Please share your excel

11

HI @nivedita,

This is the excel file : New Microsoft Excel Worksheet.xlsx (7.9 KB)

Regards
Balamruugan

12

Hi @nivedita,

It is really nice approach. It is nice.

image

Regards
Balamurugan

13

yes ,
but there isn’t any property to solve this problem

14

I tried executing my workflow using the specified excel file. My output is

image
image702×541 5.7 KB

15

Thank you @balupad14