Mapping Fields

[naveenashokan94]

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

[jyothish8807]

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

Br,

KC

[Anonymous · Accepted solution]

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

[naveenashokan94]

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

[naveenashokan94]

Thank You so much@YOGESH AREKAR

Your Solution was helpful

Thanks

[sasiparupudi1]

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