Ignore column's from flat file

[alexander_kutz]

Hello,

i'm new in BW - i try to load data from a flat file. How can I define in InfoSource / communication structure to irgnore some column's.

I.e. to igrnore the first, 4., 6..

The 2., 3., 5. and 7. are values to import.

Best regards,

Alexander

[Former Member · Accepted solution]

Hi Alexander Kutz,

Simple way is just define the data source same as your flat file(dont ignore any fields). Define communication structure only the required fields and map it accordingly in transfer rules.

or define all the fields in communication structure and map only required fields in update rules from thsis communication structure, dont map for other fields..

Hope this helps.

Srini

[alexander_kutz · Accepted solution]

To define them all in the communication structure I need for each one a InfoObject - right? I have about 50 columns to ignore. Thats a lot of work.

[Former Member · Accepted solution]

Alexander,

If you dont want to crate new info objects, create a new file that only contains the required fields.

Because datasouce shold be same as flat file. Otherwise you cant load the data.

Srini

[Former Member · Accepted solution]

Hi Alexander,

While loading the data, the funda is you can load the data from a file to a structure is both are identical. So, if both your flat file and the communication structure are not in sync, you can not load the data.

As per your issue, if you want to avoid these odd 50 columns, better create a new flat file which does not contain them and as per the new file's structure and load the data.

Hope it helps!!!!

Do not forget to assign points, if helpful.

Amit

[alexander_kutz · Accepted solution]

OK, thanks!