Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

Is there any way to import a file that doesn't have a repeating member name on each line

Originally posted by Matt Grundey

5/23/2019

Data source question, is there any way to import a file that doesn't have a repeating member name on each line. If I have a file similar to the one in the picture (but saved as a CSV or tab delimited), is there any way to load the file and have the system repeat the cost center numbers on the relevant line?


Data Sources
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    5 years ago
    Originally posted by Joakim Kulan

    There is also the option to use Stored Text Data Type in the Data Source. This will write the last rows value if no value is in current line. This option does not require any complex expressions