Subject:Conditional Processing Author:Rick Scofield Date:28 Mar 2006 10:15 AM
Hello,
I could use some help with conditional processing. I have a multi-dimensional input file that will be output into a single dimension, like transposing columns into rows.
The goal is to read the AttributesIN.csv and get AttrtibutesOUT.csv
I need to apply a condition in the xsl something like:
IF CLR same as last CLR don't output
IF DIM = "TLL" then output "SIZE","50T"
IF DIM = "REG" then don't output
IF DIM = blank then output "SIZE","50"
IF DIM = a number then output "WST",SIZE,"LGH",DIM
Subject:Conditional Processing Author:Minollo I. Date:28 Mar 2006 10:25 AM
I think a good starting point would be to start viewing the input CSV file as XML; you can do that opening the file as:
adapter:CSV:first=yes?file:///c:/AttributesIN.csv
Using that as input to an XSLT, you can design the XSLT to include the logic you are describing and generating an output of similar shape to the input (and with different fields); then you can save the result through the same CSV converter back into CSV format.
Subject:Conditional Processing Author:Rick Scofield Date:28 Mar 2006 10:39 AM
Sorry Minollo, I should have explained more detail. I have already created the .conv file and .xsl and I have output. I'm looking for some good examples of xsl: conditional processing that can get me kick-started.