Skip to Content
0
May 24, 2020 at 05:12 AM

BPC Transformation File Formula to add zero

258 Views

Hello Experts

I am putting together a transformation file to pull in master data from a flat file. The dimension I am creating in BPC is 5 characters. I the flat file, the string is either 4 characters or 18 characters. For the 18 character stings, I am using *COL(1,1:5) but for the 4 character strings, I am not sure how to add a zero at the end to make 5 characters. Or how to tell if it is 4 or 18 characters in the transformation file. Is it possible to use the formula TEXT(COL(1),"00000") or IF statement that identifies is the string is 4 characters?