Originally posted by: japfooser50

Hi,

I am new to WTX and have been tasked to create an additional detail record when a certain code is present. The additional record will have the same detail fields and data and this record, and the code will be changed on this new record to a different code. I am using an extract and member(s) to get the codes that I need, and when it is a certain code I need to create an additional record. I am looking for ideas on how to accomplish this. thank you so much for your help in this.

japfooser

Originally posted by: PaulBrett

At the group level, create another 'parent' group, containing your real group and 1 or more optional extras.  Additional rules can be populated with syntax items to make the file correct, as per the enclosed example.

Thank you

Paul

Follow me on Twitter

Attachment(s)

ExtraRecords.zip   2 KB 1 version

Originally posted by: japfooser50

Hi, 

Thank you so much, but I do not have a way to open these type trees or map source from my home computer, nor can I get these into my design studio at work.

Would you be so kind as give me some snap shots?

thanks again!

japfooser

Originally posted by: PaulBrett

At the top level, you have an output card:

You will note the presence of an additional group - 'RecSeq'.

In the functional map: 

...I map the main record, and have an IF() to test for the condition for creating the additional record.

Onto the 3rd level of functional map:

I create the additional record (prepended with syntax item <NL> to make everything look nice).

For further assistance on this topic, I suggest you get Design Studio on your home PC (along with the appropriate licensing of course).

Thank you

Paul

Follow me on Twitter

Originally posted by: japfooser50

thank you so much!

japfooser

Originally posted by: japfooser50

Hi, How did you get the 2 records to show up in your output type tree? Under recseq root. Would you please explain how this works? I can't seem to get the extra record to show up (not blacked out) where I can put my IF statement to make the call to the extra record functional map...

thank you for any help that you can give on this.

japfooser50