AnsweredAssumed Answered

Input from 1 file output to 2 files

Question asked by lwestcott440009 on Aug 17, 2018
Latest reply on Aug 21, 2018 by lwestcott440009

I need to take input from a single file and output to two files.

The output is determined from a SQL database query Stored Procedure returns two values (UPC

value, decisionfield):

if decisionfield = 1 write to a fileA  

if decisionfield = 2 write to fileB.

 

my current process with the database call within the mapping

 

I haven't been able to figure this out as yet. map function

Outcomes