My tickets
Submit ticket
Login
Data Manager
Home
>
LityxIQ Discussion Board
>
Data Manager
Ask new question
What options exist to handle duplicate records?
For example what if I have transactions by ID and want to sum them up by ID, but also keep other information about each ID like gender, age etc.?
Dec 02 (46 days ago)
1
When you choose left and right join I believe that provides the union but what if you want the intersection?
Unchecking both the boxes in the join dialog 3rd tab gives you the intersection (missing rows on either side don’t make it into the final result)
Dec 02 (46 days ago)
not commented yet
Can you suppress records using a Join?
I wanted to suppress records that are on another dataset so do a “not-in” join. Would you have to create a field on that suppression dataset and set every record to 1. Then do a normal join but then filter on the new field so only non-matching records would survive?
Dec 02 (46 days ago)
1
When reading a tab delimited file through LityxIQ how do I do that through Data Manager? I see that you do it in File Options, but not sure how you represent a tab delimiter.
Backslash-t as in: “\t”
Dec 02 (46 days ago)
3
Load more topics