Level 2 Sprint 2 Activity 2.3.9.1 Import data into DAT03 Historic Volumes module

My Export View from the Data Hub model always has the Line Items of Volumes as a column.

The first column can't be ignored in mapping. Although the data can be imported correctly, there's always an error message.

Is there a way to avoid this?

How I add pivot the view so that the Volumes wouldn't show up as a column?

Thx!

Comments

  • Hi @LeonardD

    In your import mapping, can you not use "column 1" in line items mapping instead of fixed line item?

    That should fix your issue

  • Oh yes that's exactly it! Fixed so easily!

    Thx!