Text to column activity issue

Help StudioX
,
1

Hi,

I’m currently facing an issue with the “Text to Columns” activity in UiPath. Whenever a new column is generated, its name duplicates the original column header.

This duplication has led to an error in the subsequent “Read Range” activity, indicating that a column named “invoices” already belongs to the datatable.

Could you please advise on how to prevent this duplication or any other potential issues that might be causing this error?

I aim to eliminate the duplicated column name highlighted below
image

Thanks

2

@lqxchan

Use read range but unselect the add headers option so that yhe first row is no read a sheader and the data would be read…and as the data is there from row 2…give range as A2 to make it read from second row directly

Cheers