Forum Discussion

psatkar's avatar
psatkar
New Contributor
10 months ago

How to import data in stage via excle template.

Hi All, I need help to importing data to stage via excel template. There is some instruction given in Design Doc Loading Stage Data (mcoutput.com), but its confusing. Can someone confirm what I am ...
Data Sources
psatkar's avatar
psatkar
New Contributor

Thanks Marcus,

Ad per the design doc reference, I prepared this file and created Data source and TF rules for this. but not able to import this file. This is not form its a actual data flat file. Is there someting I am missing on ?  

 

 

 

MarcusH's avatar
MarcusH
Contributor III
9 months ago

2 things to check:

 - Named range: does it exist, does it cover the lines you want to import including the header, does it begin with XFD

- Data Source: Allow Dynamic Excel Loads must be True.