The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

How do I tell OS to find the Entity code on the first line in the 4th column number?

Originally posted by Craig Masters

8/24/2018

I have a Data Source "issue"... I have 5 Tab Delimited files using the same Data Source. The Tab files only have the Entity designation on the first row in the 4th column number. No other dim is using the 4th column number. How do I tell OS to find the Entity code on the first line in the 4th column number?

Data Sources

1 Reply

  • OSAdmin's avatar
    OSAdmin
    Icon for OneStream Employee rankOneStream Employee
    6 years ago
    Originally posted by Nick Kroppe

    Can you set the Data Type to stored text and see what that gets you? This should allow the column header to be parsed once and then set for every record within your source file.