Transformation File with STR(~)

[Former Member]

Hello Gurus,

Please explain below transformation file.

*MAPPING ID=*STR(~)+LEVEL_1_ID+LEVEL_2_ID+LEVEL_3_ID+LEVEL_4_ID+LEVEL_5_ID EVDESCRIPTION=*COL(1) PARENTH1=LEVEL_2_PARENT+LEVEL_3_PARENT+LEVEL_4_PARENT+LEVEL_5_PARENT

What values will fill ID and PARENTH1 fields. What is the command STR(~) will do?

Regards,

Krishna

[former_member523998]

Anything with *STR() will append that text in the parentheses to your value.

Example: if within your ACCOUNT dimension your GL members are all prefixed with an A_ (i.e. A_500000), yet your source file only has numeric GL accounts (i.e. 500000), in a column with a header of ZACCOUNT. You could modify your incoming data to match your accounts with the transformation file as shown here:

ACCOUNT=*STR(A_) + ZACCOUNT

I think that should answer all three of your questions.

This help page has great detail on all aspects of the transformation/conversion files.

[former_member186338]

str (~) will insert "~" as a first character of ID.

LEVELXXX - values of the corresponding fields.