Discussion Board for collaboration related to QlikView App Development.
I have some questionnaire data structured as follows:
I would like to merge or combine this data into a single table and save in the following manner
Date EMPID FNumber Text
But, there are a few conditions which needs to be considered:
Can you please suggest what would be the better approach to obtain the result.
Go to Solution.
try as below
View solution in original post
stalwar1 vinieme12 swuehl
Could you please point me the right direction to use in this case. I'm confused between Concatenate and Join.
Thanks for the reply and sorry for the delay in getting back.
This looks good, can you also please let me know how do i write my conditions mentioned by following your suggested way?
this is how your data tables will join; which is based on the conditions specified, i've highlighted the key fields for reference. you don't need to write the conditions separately
we are joining table 1 and table on UID
Table2 to table 4 on FID
and Table 4 to table 3 on TID
these are for Joins not conditions of load
Your solution works perfectly for me.