Data Increment

I was trying to do something like this, I have a file which will update every once in a week so each time the number should increment by 1. Let's say this time it is B166 so next time when it refreshes it should show B167 and after week B168 and so on.... Any suggestion will be much appreciated.

THANK YOU IN ADVANCE

Workflow

Accepted answers

mceleavey

@TabsheerMohamed ,

In that case it sounds like you're trying to rename the report with an incrementing number each time.

The easiest way to do this is probably to output the number to a .yxdb file, read this in each time and create a field called "Filename". Read this number in, add 1 to it, and append it to "[Filename]+[Incremental_number]" then generate the report with the dynamic filename.

All comments

mceleavey

Hi @TabsheerMohamed ,

Which number?

Are you creating a new file every week? Are you receiving a new file every week and appending to an existing file?

Can you please provide more information?

binu_acs

@TabsheerMohamed One suggestion would be to keep the updated number in a separate file and when you run the workflow each time read this file and increment the number

TabsheerMohamed

No, actually I am trying to send out a report which used to be manual. now its in 165 and every week they will increment it by 1, so that will be 166,167, and so on...

mceleavey

@TabsheerMohamed ,

In that case it sounds like you're trying to rename the report with an incrementing number each time.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703