AnsweredAssumed Answered

Flat File profile generates delimiter even if all the inputs are null

Question asked by aishwarya.jayapal756738 on Jul 17, 2018
Latest reply on Jul 19, 2018 by aishwarya.jayapal756738

Hi All,

 

I have source file as csv file and target as (|) delimited file. I have multiple Record Details in target. For "TAXRETAILLOCATION" record i have to check for the Tax Maximum field from source and if it has value greater than 0 then only i need to map it to the target. If the field is 0 or null then  target should not be generated. Since this is delimited file it is generating the delimiter characters alone for the record. Is there any way to control this.

 

 

Target Profile:

 

Actual Output:

INSERT|TAX_LOCATION|021252218|BOSTSON|MA BOSTON|*|*
INSERT|TAX_LOCATION|1289|BOSTSON|MA BOSTON|*|*
||||||||||
||||||||||

 

Expected output:

INSERT|TAX_LOCATION|021252218|BOSTSON|MA BOSTON|*|*
INSERT|TAX_LOCATION|1289|BOSTSON|MA BOSTON|*|*

Outcomes