topic Re: Mapping and applymap() in QlikView

Mapping and applymap()

Fri, 26 Feb 2016 07:20:09 GMT

Hi All,

Please help me...

ExceptionFieldNameMaping:

MAPPING LOAD

CvisField,

DisplayFieldLabel

FROM

tab 1;

Table:

TRANSACTION_ID

as TransactionIDEELT1,

EXCEPTION_ID

as ExceptionIDEEL1,

ERROR_CODE

as ErrorCodeEEL1,

ERROR_MESSAGE as ErrorMessageEEL1,

ApplyMap('ExceptionFieldNameMaping',FIELD_NAME)

as FieldNameEEL1,

From Table;

In Applymap i mentioned table name but i did n't mention field name or field value from which i have in my mapping table.So that what it will return above applymap function.

thanks in advance.

please help me out this issue.

Reagrsd

prathap

Re: Mapping and applymap()

sunny_talwar — Fri, 26 Feb 2016 17:13:48 GMT

I don't understand your question, why don't you provide a valid field name in your ApplyMap()? Is that intentional? I think it will error out the table like this as it won't identify the field name

Re: Mapping and applymap()

engishfaque — Mon, 29 Feb 2016 04:07:53 GMT

Dear Prathap,

Listed below statement will not return you any result, because there is not field exist in your Table.

ApplyMap('ExceptionFieldNameMaping',FIELD_NAME)

as FieldNameEEL1

For more detail please go through,

Applymap()

Kind regards,

Ishfaque Ahmed