topic Re: How to Map the fields? in QlikView

How to Map the fields?

Anonymous — Sun, 26 Oct 2014 10:16:18 GMT

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.

Re: How to Map the fields?

ashfaq_haseeb — Sun, 26 Oct 2014 10:37:09 GMT

Hi,

Have a look at attached documents.

Regards

ASHFAQ

Re: How to Map the fields?

Anonymous — Sun, 26 Oct 2014 10:57:51 GMT

Hi Ashfaq,

Cant see the attachement

Re: How to Map the fields?

ashfaq_haseeb — Sun, 26 Oct 2014 10:59:48 GMT

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

Re: How to Map the fields?

ashfaq_haseeb — Sun, 26 Oct 2014 11:13:27 GMT

Hi,

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

Regards

ASHFAQ

Re: How to Map the fields?

Anonymous — Sun, 26 Oct 2014 12:48:13 GMT

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)

Re: How to Map the fields?

Anonymous — Sun, 26 Oct 2014 12:58:57 GMT

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

Re: How to Map the fields?

ashfaq_haseeb — Sun, 26 Oct 2014 13:18:35 GMT

Hi,

Can you attach excel file?

Regards

ASHFAQ

Re: How to Map the fields?

maxgro — Sun, 26 Oct 2014 13:30:20 GMT

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)

Re: How to Map the fields?

Anonymous — Sun, 26 Oct 2014 13:56:59 GMT

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

how shall i do it?

Regards,

Sharma

Re: How to Map the fields?

ashfaq_haseeb — Sun, 26 Oct 2014 14:01:06 GMT

Hi,

When you click on reply, on top right you will see use advance editor.

Check on that and you will have options to attach file on bottom right.

Regards

ASHFAQ

Re: How to Map the fields?

Anonymous — Sun, 26 Oct 2014 14:05:50 GMT

No Ashfaq, I dont have that option displayed apart from Insert link as url page

Re: How to Map the fields?

ashfaq_haseeb — Sun, 26 Oct 2014 14:09:29 GMT

May be some community administrator can help you.

You can contact me via skype.

my skypeID: ashfaqhaseeb

Regards

ASHFAQ