question Re: Using UpdateAttribute Advanced Tab , property value not being populated. in Archives of Support Questions (Read Only)

Using UpdateAttribute Advanced Tab , property value not being populated.

saikrishna_tara — Sun, 18 Aug 2019 10:21:31 GMT

Hi,

I have a case where i have to route incoming flow files to different folders based on the File names. Lets say i have 1000 files that need to send to 5 folders. i thought this would work with Advanced settings of updateattribute where i can write the rules.

but the folder name is not being populated.anything wrong i am doing .?? here my test flow..List-->Fetch-->UpdateAttribute-->PutFile

and i tried to use the Folder attribute in the putfile ..i tried without single quotes also..

or is there any better approach..?? i need to route 8000 files in to 18 different folders.basically 70 files to 17 folders and remaining 7100+ files to a default folder..(per day 8K files , i need to load data for 18 months)

Thanks for your help..

Regards,

Sai

Re: Using UpdateAttribute Advanced Tab , property value not being populated.

MattWho — Tue, 15 Nov 2016 04:04:54 GMT

@Saikrishna Tarapareddy

Sounds like your Conditional EL statements are not resulting in a boolean true in your UpdateAttribute processor. After some FlowFiles get routed through the UpdateAttribute let them queue on the outbound connection (Stop the next processor). Right click on the connection and select "List queue". Click on the "view details" icon to the far left of a FlowFile and look at the Attributes on that FlowFile. Do you see the expected "Folder" attribute? is it set to the correct value?

If it does not exist, does the filename match exactly one of the provided strings in your EL condition statements?

Thanks,

Matt

Re: Using UpdateAttribute Advanced Tab , property value not being populated.

MattWho — Tue, 15 Nov 2016 04:06:02 GMT

Also recommend against putting the quotes around your folder names ('MS1' should be just MS1).

Re: Using UpdateAttribute Advanced Tab , property value not being populated.

saikrishna_tara — Tue, 15 Nov 2016 05:06:50 GMT

@Matt

it is working..my file name format has changed. it has a "-" where its supposed to have a "_" i didn't notice it earlier.

thank you.

anyway is there a better approach to this.??

Regards,Sai

Re: Using UpdateAttribute Advanced Tab , property value not being populated.

MattWho — Tue, 15 Nov 2016 05:49:04 GMT

I believe the process you have is spot on and keeps the number of processors to a minimum.

Matt