Fixed Line Item vs Column Headers

gmartini
gmartini
in Modeling

HI all,

I have a transaction list that I am trying to import that covers a teammates hours worked amount and the payment amount. I am trying to import it into a model dementionalized by things like Teammate ID, Location and the type of hours(i.e. Salary, PTO, etc). When I try to run the import using column headers to capture both "Hours" and "Salary" nothing populates. However when I import these items individually using the fixed line item method they populate. Any idea why this might be happening?

Answers

  • PujithaB
    PujithaB

    @gmartini,
    From the above information, I feel you have two sources to import into single line item or may be reverse way
    This could be the reason that you cannot do mapping
    Could you please share some screenshots to understand it better

    Thanks
    Pujitha

  • devrathahuja
    devrathahuja

    @gmartini - Can you share a snapshot of the source data & target module?

    There might be a mismatch in the name of the line item. Fixed line item settings lets you import a selected column to a fixed line item instead of trying to map it & hence might be working.

  • sobaid
    sobaid

    @gmartini, Are you importing from a file, or a model import?, A snapshot of both source structure & target mapping would be helpful.

Categories