• 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
by Gary Robinson
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
by Lityx
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
by Lityx
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
by Gary Robinson
1
Most Popular Articles
  • C-Statistic and ROC Curves
  • Edit Settings of an Insight Chart
  • Algorithm Overview - CART/CHAID
  • Algorithm Overview - XGBoost
  • Performance Analysis: Metrics to Analyze: Numeric Prediction Models
  • Edit Settings of an Insight Table
  • Performance Analysis: Metrics to Analyze: Classification Models
  • Current Version Details
  • Define the Source Settings for a Raw Dataset
  • Defining Summary Metrics in Insight
About Lityx
  • Our Home Page
  • Solutions by Industry
  • Solutions by Need
  • Resources
  • Contact Us
Powered by LiveAgent