Hello all!
How to load Multi Period data from Excel(.xlsx) into Planning using 'one-column' format for periods at Excel template ?
for example:
Account | Entity | Period | Amount |
---|
acc1 | ent1 | Jan | 100 |
acc1 | ent1 | Feb | 200 |
acc1 | ent1 | Mar | 300 |
I've already tested loading multi periods data from .txt using file type 'Delimited - Numeric Data' - it working fine! I also tested different source mappings - Explicit and Adjustment (for custom period names) - it's also working fine!
I'm also tested loading multi periods data from Excel using differents columns for periods (Jan,Feb..Dec), file type 'Multi column - Numeric Data' and Expression in Import Format period mapping - it's also working fine!
But when i'm trying to use 'one column' format at Excel template without any Expression in Import Format mapping - all rows are loading into first period - Jan!
i've been tested different ways - file type 'Delimitied..' or 'Multi column..' and Explicit/Adjustment source period mappings...still same problem, all rows are loading into one period..
Any ideas how to solve this ?
Thanks!
Best Regards,
Artem.