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
9 months ago

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.