LinkedIn
Twitter
With the Concatenate expression, I have been able to populate the field of Account for a Location. The structure is one Bill To to many locations. So, I have put together the Bill To Account number with an added number. If the Bill To is 1001, I have concatenated the new location with 1001-01. I have done this manually just to test. (The Location field is not the table key) If I were able to extract the system count, I would be able to concatenate with the Bill To creating a sequence. Is there a way to extract that count?
Solved
1 ACCEPTED SOLUTION
It took some thinking but I did figure it out. Maybe it will help others this solution. (I feel proud of myself LOL)
