Identify Duplicate Field Names in Script Error

[ivandrago]

Hi,

I have a Script Error on one of my Documents which is failing with the below message:

"Field names must be unique within table"

Is there a way of identifying which Line No of the script this is? Or is there a third party tool that would you copy the script and it would look for column names that has the same name?

Thanks

[Anil_Babu_Samineni]

That means, You should call them up into picture like

Load Name, Sales From Table;

Load *, Sum(Sales) as Sales From Table ...; // Wrong

Load Name, Sum(Sales) as Sales From Table ... // Right ?

[abeyphilip]

Hi Ivan,

If all the filed names can be copied to a single Excel column, you can identify duplicates via - .

Home -> Conditional Formatting -> Highlight Cells Rules -> Duplicate Values

option in Microsoft Excel.

Regards,

Abey

[karthikoffi27se]

Hi Ivan,

There is no third part tool to identify duplicates in script directly.

You can use excel as Abey says above.

Many Thanks

Karthik