topic Identify Duplicate Field Names in Script Error in QlikView

Identify Duplicate Field Names in Script Error

ivandrago — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Identify Duplicate Field Names in Script Error

Anil_Babu_Samineni — Thu, 11 Jan 2018 02:14:42 GMT

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 ?

Re: Identify Duplicate Field Names in Script Error

abeyphilip — Thu, 11 Jan 2018 02:26:39 GMT

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

Re: Identify Duplicate Field Names in Script Error

karthikoffi27se — Thu, 11 Jan 2018 05:46:24 GMT

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