Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 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
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    5 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.