cancel
Showing results for 
Search instead for 
Did you mean: 

Conditional Operator

Former Member
0 Kudos

Hi,

i want to create xml table based upon the input which is in non XML format.my input file contains 8 rows but 4 rows are column names (mintab to flat file parser output). after every 4 rows it contains one empty row. when i tried to convert this into xml format, i used for next and repeater. in for next i mapped as xml loader_xml content(rowsets/rowset/row/@rowname) to current item of for next loop and in repeater, i configured it as xml loader_xml content(rowsets/rowset/row/@rowname).

i used one contional operator after this repeater. i set two input values in OR condition. first input value i set as repeater_0.itemCount>=0 and second value as repeater0_currentitem==nullstring. after this i map DocColumn, row and data item.

My theme is after first 4 rows from input xml, conditional operator should consider other items as row values. but i got output as all items as columns( 8 columns).

how to get correct output? how to solve it? in conditional operator my idea is taking empty row as one input value and count for empty row as other output.

please help me.

-senthil

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

already i gave my XML file in this link

i loaded this file into XML loader then doing these operations in my previous post.

-senthil

Former Member
0 Kudos

Repeater_0.CurrentItem>4

Repeater_0.Output{/Row/Line}==""

Former Member
0 Kudos

no. still its not working. same problem arising

Former Member
0 Kudos

OR?

if item count is > than zero is will always pass.

Former Member
0 Kudos

Repeater-->Conditional(one input, Repeater_0.CurrentItem<4 )

if true, create col,

if false >Create Row>Conditional(two input AND, Repeater_0.CurrentItem>4, Repeater_0.Output{/Row/Line}!="" )

if true add value to row.