Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Generate Batch Id for files

Dear friends,

Please help me.

I want to create batch Id for every file.

One file having one batch id and another file having another batch id etc.

My source file initially dont have any batch ids. How to achieve this using a filename and time stamp or any other methods? Please help as I am new to talend...any screenshot would be helpful.

 

Thanks,

SHAMLY

Labels (2)
1 Reply
vapukov
Master II
Master II

Hi,

 

all depend from - what you want from this batch_id? 

as variant - simplest way:

  • create table with batch id's
  • when start job - read current
  • increment and write back to table when you need

 

for example in our case batch id - it not for each file, but for all files from this batch.

so in sequence of jobs we open batch - assign number and store in database table

than each job in same batch use this number - read from table

final job - close the batch, update column in the table