Forum Discussion
It looks like you’re trying to extract the number at the end of the “Test_company” string? Is that right?
Nope, I need to generate the sub sequence under each cost center, Like For cost center 001, I have 2 companies, so the sequence is provided accordingly.
I was looking for usage for variable field where I can increment the value if the prev and current record are of same cost center and reset the variable to 1 if there is change in cost center. (By providing sorted data to the variable defined).
Seems there is no concept of variables/caching data in snaplogic, please help me otherwise.