1 person found this helpful
Have you considered loading the multiple account columns into attribute columns and then performing a SQL UNPIVOT operation in an Event script to transpose the multiple columns to individual rows? For other options check out this previous discussion on the same topic Intragroups or how to load 2 data field into one amount field
Thanks SH for your quick reply ! and francisco for the blog
this is comletely new for new, can you please sugges or guide me with samle code of SQL unpivoting in ecent script ?, and I guess Unpivoting should haapen in either AftValidate or BefLoad scripts which will process TDATASEG table..right ?
Also, since all the accounts values are in columns, i am confused how can i manage it in Import format , i mean which column should i choose for Account and Amount..?
Thnak you very much
Thanks SH for the idea of using ATTR dimensions. I am good to load my file now.
Solution: I imported the file in TDATASEG and then run SQL query to unpivot it from ATTR columns to Accounts/Amount and then export to essbase.