on 06-28-2006 10:46 AM
hi
i have flat file -> idoc scenario and I want to use mapping/cr8 user-defined function to count ALL the lines of the xml file
I tried to use index function with remove context and split by value and it didnt help ( mayb i did it wrong )
if i use count function i have to use it on EACH line and add all
the flat file MT is
Integral_MT
___________IDOC
__________________H_Line (1)
__________________L_Line (unbounded)
__________________V_Line (unbounded)
any suggestions?
thx
Shai
Hi,
You can use user defined function. Handle the context. just return the length.
Regards,
Kavita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
put the context to the parent node (maybe the MT itself), then use a UDF like
public void RecordCount(String[] a, .....)
{
tempCount = a.length;
........
}
for each node once you get the count pass them to a add function or create onto handle the add with the number of inputs (the count functions) and return the total number of count.
Hi,
You just need to write one liner code in function.
result.addValue(Integer.toString(a.length));
and change context to root.
-Kavita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the flat file MT is
Integral_MT
___________IDOC
__________________H_Line (1)
__________________L_Line (unbounded)
__________________V_Line (unbounded)
Your UDF sud look like
public void count(String[] a,ResultList result,Container container){
//write your code here
int i = 0;
i = a.length;
String val = String.valueOf(i);
result.addValue(val);
}
and the context for
IDOC
H_Line (1)
L_Line (unbounded)
V_Line (unbounded) sud all be Integral_MT
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.