Hello experts,
I have a idoc to file scenario. the incoming Idoc can have multiple records in it and i have to map these records to a csv file. Now the problem is not all records has to be mapped to the file. Based on the value of a perticular file (which is not root), i need to decide if the entire record has to be processed or not. Like the idoc structure is say:
IDOC
E1WPA01 0....9999
E1WPA04 0...99
KONDART 0..1
Now for all valid E1WPA01 where the value of KONDART equals to some spacified value (known) , there has to be one record in the target csv file.
How can this be done at the root level?
One way of doing is we give empty values in the target file where the condition of KONDART is not fulfilled. Say if there are 10 records of E1WPA01 and only 4 satisfies the condition, we will ahve 10 records in the output file but only 4 records will have value and the rest 6 will be blank like (,,,,,,,). But I dont want this. I want only 4 records in the output file.
I tried mapping like this:
E1WPA01----
>Advanced -
> Root
E1WPA04-KONDART---->UDF
The problem i am facing here is if 4 records fulfill the condition, the first 4 are taken and the revelent 4.
Please help.
Regards,
Yash