topic Re: Field Names Must Be Unique within Table?????????? in QlikView

Field Names Must Be Unique within Table??????????

Tue, 30 Jun 2015 15:02:42 GMT

Field names must be unique within table

NoConcatenate

Fact_Interactions:

LOAD AutoNumberHash128(InteractionId, CreateTimestamp, TransferFrom, ConferenceFrom) as %QVTransactionId,

autonumberhash128(AgentId) as %AgentIdKey,

autonumberhash128(GroupId) as %GroupIdKey,

autonumberhash128(QueueName) as %QueueNameKey,

autonumberhash128(ChannelObjectId) as %ChannelIdKey,

autonumberhash128(CreateTimestamp) as %DateKey,

MediaType as [Media Type],

ChannelObjectId as [Channel] ,

QueueName as [Queue Name],

Origination as [Origin],

InteractionDirection as [Interaction Direction],

CreateTimestamp as [Create Time],

AcceptTimestamp as [Accept Time],

AbandonTimestamp as [Abandon Time],

IVRTreatmentTime as [IVR Time],

ProcessTime as [Process Time],

PostProcessTime as [Post Process Time],

TotalTime as [Total Time],

IVRTreatmentTime as [IVR Time],

CallLeg1PostDialDelay as [Leg1 Delay],

CallLeg2PostDialDelay as [Leg2 Delay],

CallLeg1AnswerTime as [Leg1 Answer Time],

CallLeg2AnswerTime as [Leg2 Answer Time]

resident

Temp_Interactions

Why Am I getting this error , I do not see any simlarly named columns?

Re: Field Names Must Be Unique within Table??????????

rubenmarin — Tue, 30 Jun 2015 15:06:22 GMT

Hi Brad, IVR Time is duplicated.

Re: Field Names Must Be Unique within Table??????????

alexandros17 — Tue, 30 Jun 2015 15:07:30 GMT

Load only a set of fields (the first 5 for example) and verify if the error still comes, add other fields and verify again ...

Re: Field Names Must Be Unique within Table??????????

stigchel — Tue, 30 Jun 2015 15:07:55 GMT

IVRTreatmentTime as [IVR Time],

ProcessTime as [Process Time],

PostProcessTime as [Post Process Time],

TotalTime as [Total Time],

IVRTreatmentTime as [IVR Time],

Duplicate IVR time

Re: Field Names Must Be Unique within Table??????????

Tue, 30 Jun 2015 15:10:07 GMT

Thanks , not sure how I missed that

Re: Field Names Must Be Unique within Table??????????

jagan — Tue, 30 Jun 2015 15:13:58 GMT

Hi,

In the load statement you have two field names with the same name, rename one of them the issue will be solved or remove one column if you do not require.

Fact_Interactions:

LOAD AutoNumberHash128(InteractionId, CreateTimestamp, TransferFrom, ConferenceFrom) as %QVTransactionId,

autonumberhash128(AgentId) as %AgentIdKey,

autonumberhash128(GroupId) as %GroupIdKey,

autonumberhash128(QueueName) as %QueueNameKey,

autonumberhash128(ChannelObjectId) as %ChannelIdKey,

autonumberhash128(CreateTimestamp) as %DateKey,

MediaType as [Media Type],

ChannelObjectId as [Channel] ,

QueueName as [Queue Name],

Origination as [Origin],

InteractionDirection as [Interaction Direction],

CreateTimestamp as [Create Time],

AcceptTimestamp as [Accept Time],

AbandonTimestamp as [Abandon Time],

IVRTreatmentTime as [IVR Time],

ProcessTime as [Process Time],

PostProcessTime as [Post Process Time],

TotalTime as [Total Time],

IVRTreatmentTime as [IVR Time],

CallLeg1PostDialDelay as [Leg1 Delay],

CallLeg2PostDialDelay as [Leg2 Delay],

CallLeg1AnswerTime as [Leg1 Answer Time],

CallLeg2AnswerTime as [Leg2 Answer Time]

resident

Temp_Interactions