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”

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?

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)

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.?

Load more topics