Forum Discussion

MarkHoughton's avatar
MarkHoughton
Contributor
9 months ago

How can I ( if possible ) set a UD static value from a data source based on contents of a column

Hi, I have a data source, where the leading character of the alphanumeric values in the column are used to identify if the row value should be assigned to a particular dimension field in a UD. The ...
Transformation
MarkHoughton's avatar
MarkHoughton
Contributor

Hi Krishna,

Sorry, I am not really understanding what you are suggesting. What I have in my import file is a GL code prefixed with an "O", "X" or "R" and then a 6 digit number. What I want to do is based on that leading letter "O","X" or "R" is to assign a value to UD2 of "O","X", or "R".  I cannot do it in transformation rules as "O123456" and "R123456" map to the same OneStream Accounts code, but I want to differentiate them using UD2. So I am not sure of the correct syntax to write to UD2 using a data source complex expression.

What I can do is edit the source file before importing and run a script on that to assign the O,R, or X but would like for this to be done within the data source rule in OneStream ( if possible ).

Thanks

Krishna's avatar
Krishna
Valued Contributor
9 months ago

Hi MarkHoughton - Sorry for the confusion. Here we go. It is a Parser Business Rule. and you can attach it to the UD2 member in your datasource. 

 

								'Accounts - If the Account is the first column in your file 
				Dim Acct As String() = args.Line.Split(",")
				Dim AcctStr As String = Acct(1).Trim
				Dim UD2Final As String = String.Empty
				
				If AcctStr.StartsWith("R") Then
					
					UD2Final = "R"
					
				Else If AcctStr.StartsWith("X") Then	
				
				UD2Final = "X"
				
				
				Else If AcctStr.StartsWith("O") Then	
				
				UD2Final = "O"
				
				Else
					
					'Other 
					
				End If

				Return UD2Final

I assume the below you are trying to achieve