Loading a Flat File ...

[former_member215107]

Hi everybody,

I want to load the following data in an infocube:

Airport ¦ CALMONTH ¦ VALUE

These data come from a flat file which has the following structure:

Airport | 01.08 | 02.08 | 03.08 ... | 12.08

CDG | 2112 | 2878 | 2999 ... | 2450

BCN .....

How can i proceed to load this data in my infocube ?

I would like this format:

CDG | JAN.08 | 2112

CDG | FEB.08 | 2878

CDG | MAR.08 | 2999

....

Thanks

Rodolphe.

[claudio_ciardelli2 · Accepted solution]

With a file format as yours, I would suggest either

1) to ask the provider of the file to change his layout to : Airport : Yera/Month : Amout

2) to convert to the right format yourself via an ABAP program that read the file with 12 amounts per line and outputs a file with format Airport : Yera/Month : Amout

I believe both these solutions would be easuer than to try to build a transformation that does the conversion from 12 amounts per line to 1 amount per line.

Claudio

do not hesitate to give points if the answer is useful to you