Mapping Load

[Anonymous]

Hey community,

i have this script and i write "A, Jan, 100"  twice  i try to understand if i can see both of the line together at table view.

the only way i can see the total of them is at Pivot table.

but i want to see germany jan twice

Thx

CustomerTable:

Mapping Load * Inline

[

CustomerID, Country

A, Germany

B, France

C, Italy

D, Poland

E, Spain

Z, UK

H, ISRAEL

A, Germany ];

Sales:

Load *,

ApplyMap('CustomerTable', CustomerID, 'Unkown Country ') As CustomerCountry

Inline

[

CustomerID, Month, Sales

A, Jan, 100

A, Jan, 100

B, Jan, 200

C, Jan, 300

D, Feb, 150

E, Mar, 200

F, Apr, 100

A, May, 140

D, May, 80

E, May, 100

F, Jun, 150

Z, Apr, 100

];

[sunny_talwar · Accepted solution]

May be add a new field using RowNo() which makes both instances of Jan unique:

CustomerTable:

Mapping Load * Inline

[

CustomerID, Country

A, Germany

B, France

C, Italy

D, Poland

E, Spain

Z, UK

H, ISRAEL

A, Germany ];

Sales:

Load *,

  RowNo() as SNo,

  ApplyMap('CustomerTable', CustomerID, 'Unkown Country ') As CustomerCountry

Inline

[

CustomerID, Month, Sales

A, Jan, 100

A, Jan, 100

B, Jan, 200

C, Jan, 300

D, Feb, 150

E, Mar, 200

F, Apr, 100

A, May, 140

D, May, 80

E, May, 100

F, Jun, 150

Z, Apr, 100

];

[Anonymous]

Have you tried a Straight Table, as opposed to a Pivot Table ?

[veidlburkhard]

Hi David,

the best way will be to use Sunny's idea and put it into a straight table in UI:

Hope this helps

Burkhard

[Anonymous]

Hey @bill.markham yes i did its show me the result on the pivot table also i try to see the result on the regular table.