Discussion Board for collaboration related to QlikView App Development.
What is the best way to consolidate user data so i have just one record per email with whichever field is populated
eg if i have this sort of thing in a file
i want to end up with this sort of thing so i have one row per email with data wherever data is populated in a field for the user
Any ideas greatly appreciated
Try something like this:
MinString(Telephone) as Telephone,
MinString(Mobile) as Mobile,
MinString(Membership#) as Membership#
(html, codepage is 1252, embedded labels, table is @1)
Group By Email;
In this particular scenario, MinString worked because '-' were read as '-'. If you have true Nulls, then try with MaxString
MaxString(Telephone) as Telephone,
MaxString(Mobile) as Mobile,
MaxString(Membership#) as Membership#
View solution in original post
Did you just extract the data from the table that is posted in this thread?
How does that even work..
Perfect - Thank You...again
There is an option to load data from the 'Web File...' in the data load editor