Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I have synthetic keys in application its giving unwanted results
Budget value is different with the excel data
could some one help me to avoid synthetic keys
Please find the attachment
Thanks In Advance
Niranjan
you can use your mastercalendar field for join Budget, Actual, Forecast tables with MasterCalendar
Month(Date) & '-' & Year(Date) AS CalendarMonthAndYear
Make a composite key, like Month & '-' & Year as CalendarMonthAndYear for each Budget, Actual, Forecast tables
And concatenate FC, AC, BU data to the one table:
Hi Niru
You can replace the fields in tables Budget, Actuals and Forecast that is is synthetic table (Business Unit, Oscar Account Line, Year and Month) by an Key Number e.g., using AutoNumberHash128. After this, link the MasterCalendar with others tables using he same technique.
Hope I helped.
Márcio.
Hi Rodrigo,
Please tell me how can i use
i don't know exactly how to use AutoNumberHash128
if you don't Mind Show me how can i do that, I can follow
Best Regards,
Niranjan
you can use your mastercalendar field for join Budget, Actual, Forecast tables with MasterCalendar
Month(Date) & '-' & Year(Date) AS CalendarMonthAndYear
Make a composite key, like Month & '-' & Year as CalendarMonthAndYear for each Budget, Actual, Forecast tables
And concatenate FC, AC, BU data to the one table:
Nirajan
The AutoNumberHash128 function works like this (extracted from Qlikview help):
AutoNumberHash128 (expression {, expression})
Computes a 128-bit hash values of the combined input expression and returns a unique value for each integer value
distinct hash encountered during script execution. this function can be used, for example, to create a representation of compact memory of a composite key.
Example:
AutoNumberHash128 (Region, Year, Month)
Use it with the fields that are common in the tables, creating one for each table.
Hi Konstantins,
There are two more fields Busines Unit and Account line also
again synthetic will happen,
please find the application guide me i can do that
i am little bit confused
Best Regards,
Niranjan
Thank you So much Konstantins,Grete Technique
you made my day,Thanks Again