|
next
|
Subject: XSL record lookup via a external file Author: Rick Scofield Date: 18 Sep 2006 01:21 PM
|
Hi Guys,
I have a flat file as input (from my supplier) with product numbers and attribute data which get transformed into another flat file that is used to update inventory quantities on my web site. My problem is that some of the products from the input file are no longer available or being made, so I want to lookup that product number in a external file during the transformation to determine the validity. If the product number exists in the external file, then write the transformation/record to the output file, otherwise skip it.
Any help would be much appreciated!
THX
<input file>
AB200 DST30 30 035481423321000006320061007
AB200 DST30 31 035481423338000003620060930
AB200 DST30 32 035481423345000014720060930
AB200 DST30 33 035481423352000005520060930
<output file>
B200|[CLR]=DST,[LGH]=30,[WST]=30|0000063|035481423321|1,2,3,4
B200|[CLR]=DST,[LGH]=30,[WST]=31|0000036|035481423338|1,2,3,4
B200|[CLR]=DST,[LGH]=30,[WST]=32|0000147|035481423345|1,2,3,4
B200|[CLR]=DST,[LGH]=30,[WST]=33|0000055|035481423352|1,2,3,4
|
|
|
|