How to import a csv file into a module where the only reference is a single line item (text format)

Options
LimPhingHua
LimPhingHua Member, ALL USERS Posts: 5 Occasional Contributor
in Extensibility

Hi,

Any idea how to import this csv file:

LimPhingHua_0-1630062158213.png

into this module:

The third column (PR Number) is in text format (8 characters truncated from the first column) and its not a list nor a parent/child of the first column (PR line).

Parent of the first column (PR line) is something else i.e Material. 

 

LimPhingHua_1-1630062264474.png

 

I have nothing  from Source to match with PR (Target)

LimPhingHua_2-1630062866646.png

 

LimPhingHua_3-1630063039564.png

 

Tagged:

Comments

  • LimPhingHua
    LimPhingHua Member, ALL USERS Posts: 5 Occasional Contributor

    I did that earlier.  Created a flat list of PR Number  and another new module with PR Number as dimensions and line items for the data input. But had trouble with getting the LOOKUP formula right to get the data into the target module  (Dimension issues). The new module created with the new list after import as below:

    LimPhingHua_0-1630071319218.png

    I couldnt get the data into the target module below with Lookup formula.

     PR No in new module (above) is list and PR Number in target module (below)s a text property

    (truncated 8char from PR Line eg 12176647-10-00).

     

    LimPhingHua_1-1630071543725.png

     

  • LimPhingHua
    LimPhingHua Member, ALL USERS Posts: 5 Occasional Contributor

    New module dimensions: PR2 and line items:

    Note: PR2 is the list generated from PR numbers earlier. 

    csv. file data import into this module with no problem.

    LimPhingHua_0-1630072253827.png

    Target module has dimensions PR and line items as below

    (Third column in this module although named as 'PR Number' is actually text ...not from list )

    I tried LOOKUP...tried SELECT and have no idea how to make it work

    LimPhingHua_2-1630072526803.png

     

     

     

  • LimPhingHua
    LimPhingHua Member, ALL USERS Posts: 5 Occasional Contributor

    Its working!

    Thank you

    LimPhingHua_0-1630089020124.png

     

Categories