Missing column in CSV file when the column is blank value

[Former Member]

Hi Guru,

I encounter 1 problem where the output CSV file is missing certain column. The reason is due to the column is blank value. If i put in certain value, the column will come out.

Does anyone can help me to solve this problem?

Thanks in advance...

[Former Member]

Expected reault

M1234,S001,10 ---> Wrong result

M1234,S001,,10 ---> Correct result

Check the mapping for field Location, Check the corrosponding Source field and follow the mapping lik

Source Field - Exists> If True map with source field to Target

--> If False map with Constant by giving a space.

Or you can use mapwithdefault function.

Hope it will helps

Cheers

Veera

[Former Member]

Your problem statement is not clear. Can you give a sample XML and the expected result (text file). I hope you are using FCC at receiver FIle adapter.

Regards,

Jai Shankar

[Former Member]

Hi Shankar,

Yes. My receiver adapter is File.

Example, CSV file format consists of Matnr,Plant,location,Qty.

Because location is blank value. As the result, when i open the CSV file, i do not have the location column.

Expected reault

M1234,S001,10 ---> Wrong result

M1234,S001,,10 ---> Correct result

[Former Member]

>>>Because location is blank value.

How does the XML look like? Hence I asked for the XML file.

I assume you dont have the Location tag in your XML. If I am correct, then all you need to do is change the occurance of Location tag from 0...1 to 1...1.

Regards,

Jai Shankar