topic Re: Mapping Fields in QlikView

Mapping Fields

naveenashokan94 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am Facing this issue,cant find a solution.

Looking forward for any idea or solution,

I have attached the Data set and the Question Below Please find the attachment.

Thanks In Advance

Re: Mapping Fields

jyothish8807 — Tue, 05 Jun 2018 06:20:10 GMT

Are you giving any exam ? Then seeking help in community wont be a good practice.

Br,

Re: Mapping Fields

Anonymous — Tue, 05 Jun 2018 06:25:20 GMT

Hi Naveen,

Try this ,

Mapping1:

Mapping

LOAD ID1,

Price

FROM

[..\Downloads\Data source_Task.xlsx]

(ooxml, embedded labels, table is Price);

Mapping2:

Mapping

LOAD ID2,

Price

FROM

[..\Downloads\Data source_Task.xlsx]

(ooxml, embedded labels, table is Price);

Mapping3:

Mapping

LOAD Name,

Price

FROM

[..\Downloads\Data source_Task.xlsx]

(ooxml, embedded labels, table is Price);

Master:

LOAD ID,

Name,

Status,

if(Status='Imported',null(),ApplyMap('Mapping1',ID,ApplyMap('Mapping2',ID,ApplyMap('Mapping3',Name,[Dummy Price])))) as Price

FROM

[..\Downloads\Data source_Task.xlsx]

(ooxml, embedded labels, table is Master);

Hope this will be helpful to you

Re: Mapping Fields

naveenashokan94 — Tue, 05 Jun 2018 06:26:55 GMT

Its not about exam..I am facing difficulty with this task...if you are aware of that then post your suggestion and not about questioning the posts!!!

Thanks

Re: Mapping Fields

naveenashokan94 — Tue, 05 Jun 2018 06:44:32 GMT

Thank You so much@YOGESH AREKAR

Your Solution was helpful

Thanks

Re: Mapping Fields

sasiparupudi1 — Tue, 05 Jun 2018 08:12:05 GMT

if you got your answer, pl close this thread by marking any helpful and a correct answer