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

LeonardD
LeonardD
edited April 14 in Academy Discussions
image.png

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.

image.png

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!

Answers

  • HimanshuRaj
    HimanshuRaj

    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

  • LeonardD
    LeonardD

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

    Thx!

Categories