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

[#1]

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?

[rubenmarin]

Hi Brad, IVR Time is duplicated.

[alexandros17]

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

[stigchel]

     IVRTreatmentTime as [IVR Time],

     ProcessTime as [Process Time],

     PostProcessTime as [Post Process Time],

     TotalTime as [Total Time],

     IVRTreatmentTime as [IVR Time],

Duplicate IVR time

[#5]

Thanks , not sure how I missed that

[jagan]

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