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

Options
LeonardD
LeonardD
edited April 2023 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
    Options

    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
    Options

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

    Thx!

Categories