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
Hi @anupgupta12
Is there a reason you want to use the block until done tool? You should be able to leverage the output tool settings to dynamically create the files based on a field. See attached example of this that dynamically creates the file name and outputs the data to separate excel files.
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?
@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.
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.