Hi, I am been working diligently all day on a single problem and am coming up empty. The problem never occurred during the training and need some advice. Basically, when I import the "SYS08+Employee+Details" txt file into sys08 file unfortunately even though I map correcty the Role dimension, which I formatted as a list, Role, comes in blank. Never during training did i see this issue. I have the lookup formulas right, using the Sys08 module as bridge between "EMP02 Employee Expenses" and "EMP03 Employee Drivers by Role" modules.
Please help, been dealing with this since 9am today.
I tried converting the text file to excel as well but that didnt help. Manually I can grow through and build an automation formula in excel to convert single digit numbers to 3 digit numbers by adding 2 zeros in front and 2 digit numbers to 3 digit numbers by adding 1 zero in front before importing, but am hoping there is a simple Anaplan fix?
I redownloaded the .txt file and it gave me right 3 digit code so all set now and got full code map matching for file. Not sure why it worked, but after trial and error it works. Thank you for your help.