topic Re: Issue in Mapping 2 tables and data load in QlikView

Issue in Mapping 2 tables and data load

Anonymous — Tue, 27 Feb 2018 12:51:49 GMT

Hi friends,

I am facing following issue.

I have 2 tables.

Table 1 , Table 2.

I am creating a mapping to get a new report view .But i am getting below error. Attached all reference document.Anyone please help me.

Field "Sub Function" not found error.

Also attached the code which i wrote.

Please help me to resolve,any other alternate way to get the desired report also will do.

Thanks

S, Prakash

Re: Issue in Mapping 2 tables and data load

jwjackso — Tue, 27 Feb 2018 12:57:54 GMT

Table1.xlsx does not have the field "Sub Function". Should this be Table2.xlsx?

Map1:

Mapping Load

[Sub Function],

[Test Stream]

FROM [lib://Bionics/Table1.xlsx]

(ooxml, embedded labels, table is Table2);

Re: Issue in Mapping 2 tables and data load

sunny_talwar — Tue, 27 Feb 2018 12:58:26 GMT

I think you are loading from Table1, whereas the Sub Function field reside in Table2.xlsx

Map1:

Mapping Load

[Sub Function],

[Test Stream]

FROM [lib://Bionics/Table2.xlsx]

(ooxml, embedded labels, table is Table2);

Re: Issue in Mapping 2 tables and data load

pablolabbe — Tue, 27 Feb 2018 19:27:54 GMT

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

Re: Issue in Mapping 2 tables and data load

Anonymous — Wed, 28 Feb 2018 14:06:14 GMT

Hi,

I tried with Table2 also.still facing the same issue.

Re: Issue in Mapping 2 tables and data load

sunny_talwar — Wed, 28 Feb 2018 14:21:17 GMT

Tab name is Sheet1 vs Table2