Expand my Community achievements bar.

SOLVED

Create workflow to rename folder label

Avatar

Level 4

Hi,

How can I create workflow to update folder label. 

Folders inside country should capitalized first letter and 1 blank space before paranthesis.

 

Eg. of correct - product (India)

Eg. of incorrect - Recipient(India)

 

tejashriw155148_0-1588597709303.png

 

Thanks,

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Select all the folders with parent folder label equals to 'India' and plug it to 'Update data' activity where you update the label.

 

 

Query Activity

  • [parent/@label] == India

 

 

image.png

 

 

Update data activity:

  • Operation type: update
  • Record identification : Directly using the targeting dimension
  • Updated dimension to xtk:folder
  • destination label
  • source expression [target/@label] + ' (India)'

 

 
 

image.png

 

 

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

Select all the folders with parent folder label equals to 'India' and plug it to 'Update data' activity where you update the label.

 

 

Query Activity

  • [parent/@label] == India

 

 

image.png

 

 

Update data activity:

  • Operation type: update
  • Record identification : Directly using the targeting dimension
  • Updated dimension to xtk:folder
  • destination label
  • source expression [target/@label] + ' (India)'

 

 
 

image.png

 

 

Hi @Marcel_Szimonisz 

 

Thanks for the solution. I ran the workflow and its updating country name instead of rename like

 
 
 
 
 

renameFolderPNG.PNG

 
 

It means if subfolder does not contain country name then need to add country name and if country name already exist then it should update with correct naming convension.

 

Thanks,                            

 

 

Avatar

Community Advisor
You should have added condition in the first query where the Lower([folder/@label]) does not contain india

Hi @Marcel_Szimonisz 

 

How can we update subfolder if it already contain India with required format?