This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hi Qlik Enthusiast,
I am building a datamodel and getting stuck with bringing the right data and removing synthetic keys.
I have 2 files(File A and File B) and I have created facts and dimensions out of these 2 files.
Fact has Emp Id, Enitity Id, Revenue etc and Dim has Entity Name, Geography, Function etc.
When I join these with the help of Emp Id, I don't get correct output for Entity Name.
When I join with Entity Id then I get correct data for Entity Name but not the right Employee Id gets picked up.
For testing, I joined with Emp ID and Entity ID, I am getting the right output but this leads to synthetic table.
Solution or any advice would be highly appreciated.
Thanks in Advance.
on both tables, you should create a composite key, like this:
Autonumber([Emp ID]&[Entity ID]) as Key
and remove [Emp ID] and [Entity ID] fields from your tables
PS: you can create composite key without functions like Autonumber(), like this: [Emp ID]&[Entity ID] as Key
it is a matter of optimization
View solution in original post
Can you share your data or sample application?
Which one would you suggest? Autonumber or Autonumberhash128?
it depends on the amount of data you load.. and on other things that I ignore.. on a small/medium set of data I put whatever comes in mind. when it comes to heavy datasets, I automatically do some benchmarking
Have you try rename your fields for asociate you datamodel?
For be more helpfull, could you share to us more information, one pic, or a dataset to help you!
you're welcome, good luck