cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

Data lost when joining table

UserID16644
Level V

Hi all,

I am trying to join 2 data tables but the data from my second data table kept on losing. I don't know how to do this, but I am using three columns to match. Is joining the table affected on how you match the data? Pls help

3 REPLIES 3
pmroz
Super User


Re: Data lost when joining table

If you can supply some example data we would be better able to assist you.

UserID16644
Level V

Re: Data lost when joining table

Here's my sample data and sample script

Data Table( "sample2" ) << Join(
    With( Data Table( "sample1" ) ),
    By Matching Columns( :SliderSN = :SliderSN, :STO_I1 = :STO_I1, :STO_I2 = :STO_I2 ),
    Drop multiples( 0, 0 ),
    Include Nonmatches( 1, 0 ),
    Preserve main table order( 1 )
)
jthi
Super User

Re: Data lost when joining table

What sort of table do you want to end up with? The data from second table could have lost because there is nothing to match the table 1 with and you are using left join.

 

Try playing around with different types of include-non-matches options with enable match flag enabled. Also you can enable Keep Dialog Open to prevent modal from closing after pressing Apply. Makes it easier to test different options. 

jthi_0-1636089837457.png

 

You could also try concatenating the data because you have same columns

jthi_1-1636090127498.png

 

 

-Jarmo