Autogenerate a number in a variable

[helen_pip]

Hello,

My load script contains details about the end user, and splits the user into 2 groups dependant on whether they are allowed access to identifiable information or not

I then apply the following variable to all fields which contain identifiable information:

='Content Hidden' & UniqueID

The end user will either see the text "Content Hidden" or the actual identifiable information dependant on the security applied in the load script

Through testing I have noticed that the data in tables is being grouped up and not showing all information when this variable is applied for those who cannot see ID's

I want to know whether I can put another unique identifier on Text I.e. ContentHidden1

                                                                                                    ContentHidden2

                                                                                                    ContentHidden3

                                                                                                    ContentHidden4

Does anyone have any suggestions?

Kind regards

Helen

[kkkumar82]

Not really understood your requirement but if you are adding data the "ContentHidden" in the load script then you can also add numbers in the same by using RowNO() or RecNO() .

Like

'ContentHidden1' &rowno() &Your field .....

Hope it helps

[#3]

hi Helen,

Use  'contenthidden'&Rowno()  this should solve the purpose.

If you have any other requirement , then please elaborate your question.

[MarcoWedel]

Hi,

maybe one solution could be to generate a separate field with the 'hidden' information (yet distinct to use it as dimension):

LOAD FieldContainingIdentifiableInformation,
          'Content Hidden' & Autonumber(FieldContainingIdentifiableInformation, 'FieldContainingIdentifiableInformation') as FieldContainingIdentifiableInformationHidden
FROM ...

hope this helps

regards

Marco

[MarcoWedel]

or maybe in the front end:

='Content Hidden' & FieldIndex('FieldContainingIdentifiableInformation', FieldContainingIdentifiableInformation)

hope this helps

regards

Marco