My tickets
Submit ticket
Login
Data Manager
Home
>
LityxIQ Discussion Board
>
Data Manager
Ask new question
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”
Sep 23, 2016
3
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 f...
Aug 18, 2014
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)
Aug 18, 2014
not commented yet
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.?
Sep 10, 2014
1
Load more topics