+6Appreciate your assistance here.... The left screen is the CVS loaded PnL Acct dimension and the right screen is NetSuite Integration. The Coln dimension 'FP&A Category Override' is a user manual input. Is there a way I may do a 'vlookup' in the new table so that we don't have to manually map it again.
Best answer by sethbradley
Hi Louie,
Seeing as Internal ID is a unique ID, try this and let me know if it works:
IF(CSV_List.‘Internal ID’ = Net_Suite_List.‘Internal ID’, CSV_List.’FP&A Category Override’)[REMOVE LASTNONBLANK: CSV_List]
Best,
Seth
+8Hi Louie,
Seeing as Internal ID is a unique ID, try this and let me know if it works:
IF(CSV_List.‘Internal ID’ = Net_Suite_List.‘Internal ID’, CSV_List.’FP&A Category Override’)[REMOVE LASTNONBLANK: CSV_List]
Best,
Seth
+12Of course !
In your target write the following:
PnL Acct dimension.’FP&A Category Override’[BY:transactionlist.’FP&A Category Loaded’]
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
