block until Done Tool

Question

Hi There!

I need help with Block until Done Tool. In below example  if the column data1 has value  "2001" then write output to a different file or if Data1 has value "2001" and 2002 or 2003 then write output to different file. how it can be done with block until done tool?

Example:-

Data1

2001

2002

2003

DawnDuong · Answer

hi @anupgupta12

I don't think "Block until done" can help achieve what you are looking for. can you post an example input and output to illustrate the problem statement?

dawn.

Luke_C · Answer

@anupgupta12 The solution I posted dynamically creates the files based on the attributes present. If there's only 2001 only one file is created with 2001 records. If there's 2001, 2002, and 2003 then 3 files are created containing the appropriate data. Let me know if you have any question.

anupgupta12 · Answer

Hi - Yes, because each month data will be changed, may be next month I only have "2001" or next to next month I can have "2001" and "2002" or "2003". So basically what i want is to write to output files, if value is 2001 then data should should not flow to 2nd output tool.

How can i do that?