Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
please provide me some information .
Autonumber(company&'#' &department) as link
WHat does autonumber do in the above expression
Thanks in advance
It will create a unique number for each unique instance of company&'#'&department. For instance if you have a table like this:
company | department | AutoNumber(company&'#'&department) |
---|---|---|
A | Finance | 1 |
A | Marketing | 2 |
A | Operations | 3 |
B | Finance | 4 |
B | Marketing | 5 |
B | Sales | 6 |
A | Operations | 3 |
C | Finance | 7 |
B | Sales | 6 |
I hope the above example will help.
Best,
Sunny
Also find the above example in a qvw file (PFA)
Best,
Sunny
Hi,
alternatives could be:
AutonumberHash128(company, department) as link
or
AutonumberHash256(company, department) as link
hope this helps
regards
Marco