Originally posted by: Shane.kelly55

Hey guys, i have a single functional map %MAPN9 and i'd like to use it throughout my entire map.  I use it in the header and detail but a little different in each.

In the header, i pass 3 parms for N901, N902 and N903.

In the Detail i only need N901 and N902.

The header is easy enough but in the detail i tried to pass %MapN9(CardValue1, CardValue2, NONE) but it wouldnt write the N9 at the detail at all.  I dont want to have a %MAPN9_HDR and %MAPN9_DTL.

Can i do this? How do i pass an empty string in that 3rd card?

THanks!

Originally posted by: paul.brett

One way to do it would be to map a simple string of characters (that you know will never appear in the data) and in the functional map, use the SUBSTITUTE() to get rid of them, leaving an empty string.

Please review the attached example.  Test1 produces nothing in the output file.

Test2 produces the required output:

Input 1
Input 2

There are other ways to do it as well. Experiment, and post your best solution here.

Thank-you.

Paul.

Follow me on Twitter

Attachment(s)

ParmsExample.zip   3 KB 1 version