UniversalDataWriter - Using Metadata Field-String as FIlename

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

Tocki
Posts: 2
Joined: Mon Aug 03, 2015 9:52 am

UniversalDataWriter - Using Metadata Field-String as FIlename

Postby Tocki » Tue Aug 04, 2015 9:17 am

Hello,

i have a question. I want to use
Bildschirmfoto 2015-08-04 um 10.06.15.jpg
Bildschirmfoto 2015-08-04 um 10.06.15.jpg (32.4 KiB) Viewed 2379 times
the field "name" in my Metadata as the Filename in my File URL for my UniversalDataWriter.

In the Filename field i save the filename and the extension of the file (csv,pdf....)

Example: ${DATAOUT_DIR}/Filename



But it seems everything i try (partitioning key, #, ${name}) nothing works.

Any idea how i can solve that problem?

Thanks!

slechtaj
Posts: 192
Joined: Wed Aug 15, 2012 8:18 am

Re: UniversalDataWriter - Using Metadata Field-String as FIlename

Postby slechtaj » Wed Aug 05, 2015 3:52 pm

Hi Tocki,

You can use partitioning feature of the UniversalDataWriter. Basically what you need to do is to:
  • Set Partition key attribute of the writer to the field you want to use in the filename
  • Next you need to define the Filer URL. To the place where the Partition key is supposed to be used write hash tag (#) - this is a placeholder for the key. So taking your example into account, it may look like this: ${DATAOUT_DIR}/#
  • If you do not want to write value of the field used in the URL you can exclude it using "Exclude fields" attribute of the writer.

Hope this helps.
Jan Slechta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

How to speed up communication with CloverCARE support

Tocki
Posts: 2
Joined: Mon Aug 03, 2015 9:52 am

Re: UniversalDataWriter - Using Metadata Field-String as FIlename

Postby Tocki » Fri Aug 07, 2015 9:21 am

Thank you, that worked


cron