Model Builder Level 1 - Rev02 Volume Input question

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 at REV02 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

Re: Model Builder Level 1 - Rev02 Volume Input question

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 REPLIES 2
gourav1kumar
Frequent Contributor

Re: Model Builder Level 1 - Rev02 Volume Input question

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

Re: Model Builder Level 1 - Rev02 Volume Input question

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