Skip to main content
June 15, 2020

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

  • June 15, 2020
  • 1 reply
  • 0 views
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?

1 reply

June 26, 2020
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.