<< Click to Display Table of Contents >> Raynet One Data Hub > 14.0 > Connectors > Alphabetic Connector List > Veeva Vault > Prerequisites Best Practice Configuration |
Some users have multiple vaultIDs given ind the vaultId column of the extracted data. with the following IPP they will be splitted.
<import_step> <import_preprocessor> <ipp_name>pcre_explode</ipp_name> <ipp_parameters> <param><key>input_filename</key><value>30-1_veeva_vault_users_raw.csv</value></param> <param><key>output_filename</key><value>01_veeva.vault_users_normalized.csv</value></param> <param><key>pcre_column</key><value>vaultId</value></param> <param><key>pcre_expression</key><value>([^, ]+)</value></param> </ipp_parameters> </import_preprocessor> </import_step> |