How to get matching data only

[#1]

Hi Friends,

I have a big table with lot of columns with one key. For example 140,142,143,145,146 etc.

I have another table with the few keys for example 140,142.

Now I want to fetch all data from big table for only matching values for the above example 140 and 142 only.

Thanks

[alexandros17]

Let's say TableA with all values and TableB with less values:

Load * resident TableA;

inner join

Load * resident TableB;

in this way only elements from table B that are Presente in tableA will be shown

Let me know

[robert_mika]

Look here

Duplicate row Issue

or look for ApplyMap

or

post our data

[PrashantSangle · Accepted solution]

Hi,

There is Various ways

1)Load Table with few Keys then Use left join and load another table having lots of columns

2) use Exist()

1st load table having few Keys, then load 2nd table having lots of column and use where condition in that use Exist()

Regards

[MayilVahanan]

HI

You can try like this

First load the "second table contains 140,142".

Then use

Left Keep(Secondtable)

Load * from big table;

Hope it helps