topic AutoNumberHash256 in App Development

AutoNumberHash256

FrankTheTank — Tue, 12 Mar 2019 08:56:00 GMT

Hello dear community,

I have a table 'vTable'. With a number of x columns. I do not know the exact number and not the column names. Now I would like to calculate a hash value over all columns (per line).

I can calculate the number of columns with

Num(NoOfRows('$(vTable)'),'#.##0,#')			as TableRows,

and name with

FOR i = 1 to NoOfFields('$(vTable)')
Fields:
LOAD
FieldName($(i),'$(vTable)')	AS FieldName
AutoGenerate 1
;

NEXT i

how do I now get the function 'Autonumberhash256 ()' fed so that I get the desired hash value?

Thanks in advance and have a nice day 😄

Re: AutoNumberHash256

marcus_sommer — Tue, 12 Mar 2019 09:28:42 GMT

It's not quite clear for me what do you want to do. Do you want to apply the hash-logic for the columns within the table or for the records? What is the aim behind it?

- Marcus

Re: AutoNumberHash256

FrankTheTank — Tue, 12 Mar 2019 09:43:18 GMT

I want to use the hash logic for every row within the table.

so that i can compare the row with her predecessor.

Example:

Row_1: A, B, C, Hash=100

Row_2: A, D, C, Hash=105 -> i get the information that in this row is a change.

Re: AutoNumberHash256

tresB — Tue, 12 Mar 2019 09:49:32 GMT

You could probably create a variable to concatenate all the field names as a string and then use that in autonumberhash256(), like:

Let vFieldsConcatenated=;

FOR i = 1 to NoOfFields('tTable')
Fields:
LOAD
FieldName($(i),'tTable')	AS FieldName
AutoGenerate 1
;
Let vFieldsConcatenated='$(vFieldsConcatenated)'&If($(i)>1,',')&Peek('FieldName');
NEXT i

RegionSales:
LOAD *,
AutoNumberHash256($(vFieldsConcatenated)) as HashMkey
Resident tTable;

Re: AutoNumberHash256

FrankTheTank — Tue, 12 Mar 2019 12:59:58 GMT

thanks, that is excactly what iam looking for.