Read Multiple Columns

[csanders]

Hi All,

I need to read multiple columns on an Excel spreadsheet. I need to read columns A,B,C,D & P

I know how to do it if I only needed to read columns A to D but not sure on this one as I need that extra column P

[natanael.mendes]

@csanders

only needed to read columns A to D but not sure on this one as I need that extra column P

use filter datatable to remove those columns that you dont want

and create a new column with the name P

[postwick (Paul Ostwick)]

Just let Read Range read all the columns. If you really need to, you can use Filter Datatable to remove the columns you don’t want - but usually this isn’t necessary.

[arjunshenoy]

Hi @csanders

Read the entire data & store it in a data table variable yourDt. Then use this simple expression in an Assign activity:

yourDt = yourDt.DefaultView.ToTable(False,”A”,”B”,”C”,”D”,”P”)

You can include or exclude any columns as per your requirements.

Hope this helps,
Best Regards.