Hi Alberto, - welcome to Qlik.
One other point worth mentioning - take a look at the Smart Data Load feature and see if that capability helps you define your data to avoid the synthetic keys and possible circular references:
More videos like these videos are available here: New to Qlik Sense Videos
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Thank you Mike, thank you wizard...
I just re-watched the Smart Data Load video... Sadly it doesn't help since I keep getting "Data profiling could not be completed" when trying any data load with my DB...
Simple update, with this I show clearly what I want (sorry I am not allowed to send sample data):
- I will see the full_user_name of all delegated
- I can see the responsible ID ("ORIGINATOR")
It works, yes, but I can't get the full_user_name of the originator..........
I can get something like:
But of course I need: