HarshaR
Occasional Contributor

Model Builder Level 1 - Rev02 Volume Input question

Hello,

I'm working on the Model Builder Level 1 training course, I have run into an issue, need help in solving it.

The issue is atREV02 Volume Inputs module. I'm trying to import the Volume input csv file and trying to map the source to target columns, have been unsuccessful. Any help is greatly appreciated.

Regards,

Harsha Rappan

1 ACCEPTED SOLUTION

Accepted Solutions
gourav1kumar
Frequent Contributor

Hi Harsha,

When creating import action we will see first window which talks about Data headers and Data Rows. So by default

Header is 1
Data row is 2

Please change it manually and make

Header as 2
Data row as 3

Once this is done and then you map

Time - Column Headers (Change date format pattern: Periods -> YYYYMM)

Location - Column 2

Product - Column 1

Line items - Fixed Line item

Hope your result will come.

-Gourav

View solution in original post

2 REPLIES2
gourav1kumar
Frequent Contributor

Hi Harsha,

When creating import action we will see first window which talks about Data headers and Data Rows. So by default

Header is 1
Data row is 2

Please change it manually and make

Header as 2
Data row as 3

Once this is done and then you map

Time - Column Headers (Change date format pattern: Periods -> YYYYMM)

Location - Column 2

Product - Column 1

Line items - Fixed Line item

Hope your result will come.

-Gourav

HarshaR
Occasional Contributor

Thank you so very much for the solution, worked like a charm.