How to Map the fields?

[Anonymous]

Hi ,

I have an excel file  which has 3  sheets  (connections / planned / emergency) which needs to be added to the same QVD separated by flag (C / P / E) and I have a column  called 'Questions text' in each sheet   that has different information and i have to map with the same key sets (Question ID  / Flag[C / P / E]).

How shall i do that?

Regards,

Sharma.

[ashfaq_haseeb · Accepted solution]

Hi,

Have a look at attached documents.

Regards

ASHFAQ

[Anonymous]

Hi Ashfaq,

Cant see the attachement

[ashfaq_haseeb]

Hi,

you will not see document if you read this thread from inbox,

Open this thread in new window, you will see all the attached documents.

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

If it answered, then close this thread by selecting appropriate answers.

Regards

ASHFAQ

[Anonymous]

Hi Ashfaq,

Error Message :Field names must be unique within table

TTISur:

LOAD

  'E' as OBJ_TTI_Flag,

  DisplayMonth as OBJ_DisplayMonth,

     Rigs as OBJ_Rigs,

     Language as OBJ_Language,

     CostCenter as OBJ_CostCenter,

     PerformanceManager as OBJ_PerformanceManager,

     FLM as OBJ_FLM ,

     Depot AS OBJ_Depot,

     Name as OBJ_Name,

     Q2  AS OBJ_Q2,

     Q3  AS OBJ_Q3,

     Q7 AS OBJ_Q7, 

     Q11 AS OBJ_Q11,

     Q12 AS OBJ_Q12, 

     Q13 AS OBJ_Q13, 

     Q14 AS OBJ_Q14,

     Q15 AS OBJ_Q15,

     Q16 AS OBJ_Q16, 

     Q17 AS OBJ_Q17,

     Q1 AS OBJ_Q1, 

     Q4 AS OBJ_Q4,

     Q5 AS OBJ_Q5, 

     Q6 AS OBJ_Q6,

     Q8 AS OBJ_Q5, 

     Q9 AS OBJ_Q9, 

     Q10 AS OBJ_Q10

From

H:\MI Industrialisation\Data Files\TTI Surveys\TTi_SampleData.xlsx

(ooxml, embedded labels, header is 1 lines, table is Emergency)

[Anonymous]

Hi Ashfaq,

Connections and planned have been loaded and fetched the data but the Emergency was showing the error as the above message as the tables has to be distinct and i am wondering should i not use concatenate whilst storing into qvd as  u didnt do it in ur example.

Pls reply me

Regards,

Sharma

[ashfaq_haseeb]

Hi,

Can you attach excel file?

Regards

ASHFAQ

[maxgro]

you have a duplicated field (bold)

TTISur:

LOAD

  'E' as OBJ_TTI_Flag,

  DisplayMonth as OBJ_DisplayMonth,

     Rigs as OBJ_Rigs,

     Language as OBJ_Language,

     CostCenter as OBJ_CostCenter,

     PerformanceManager as OBJ_PerformanceManager,

     FLM as OBJ_FLM ,

     Depot AS OBJ_Depot,

     Name as OBJ_Name,

     Q2  AS OBJ_Q2,

     Q3  AS OBJ_Q3,

     Q7 AS OBJ_Q7,

     Q11 AS OBJ_Q11,

     Q12 AS OBJ_Q12,

     Q13 AS OBJ_Q13,

     Q14 AS OBJ_Q14,

     Q15 AS OBJ_Q15,

     Q16 AS OBJ_Q16,

     Q17 AS OBJ_Q17,

     Q1 AS OBJ_Q1,

     Q4 AS OBJ_Q4,

    Q5 AS OBJ_Q5,

     Q6 AS OBJ_Q6,

     Q8 AS OBJ_Q5,

     Q9 AS OBJ_Q9,

     Q10 AS OBJ_Q10

From

H:\MI Industrialisation\Data Files\TTI Surveys\TTi_SampleData.xlsx

(ooxml, embedded labels, header is 1 lines, table is Emergency)

[Anonymous]

Yes i will , But i dont have the editor preferences to my account

how shall i do it?

Regards,

Sharma