Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Mapping Fields

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

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Mapping Fields

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);

table.PNG

Hope this will be helpful to you

View solution in original post

5 Replies
Highlighted
Master II
Master II

Re: Mapping Fields

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

Br,

KC

Best Regards,
KC
Highlighted
Contributor III
Contributor III

Re: Mapping Fields

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);

table.PNG

Hope this will be helpful to you

View solution in original post

Highlighted
Partner
Partner

Re: Mapping Fields

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

Highlighted
Partner
Partner

Re: Mapping Fields

Thank You so much@YOGESH AREKAR

Your Solution was helpful

Thanks

Highlighted
Master III
Master III

Re: Mapping Fields

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