Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Heyyy ,
I have two tables with the common field.
How can i pick up the values from one of the field which are common in first table and second table's Fields value.
Thanks in Advance.
Regards,
Nilesh Gangurde
Hi Nilesh,
Do you want to do that in the load script or in a expression? The former can be done using the ApplyMap() or Exists() function:
Table1:
LOAD *
FROM File1.qvd (qvd);
Table2:
LOAD *,
If(Exists(FieldInTable1, FieldInTable2), 1, 0) AS ExistsInTable1
FROM File2.qvd (qvd)
The latter using a set analysis based on a new field created in the load script
Table1:
LOAD *,
1 AS Source
FROM File1.qvd (qvd);
Table2:
LOAD *,
2 AS Source
FROM File2.qvd (qvd);
The expression in a chart:
Count({< Source = {1, 2} >} NameOfField)
Hope that gives you the idea.
Miguel
hi
yo can do like this
table1:
load:
'table 1' as table
field1
field2
from yourdatabase;
table2:
load
'table 2' as table
field1
field2
from tourdatabase
then u can select fron field table
Hi Nilesh,
Do you want to do that in the load script or in a expression? The former can be done using the ApplyMap() or Exists() function:
Table1:
LOAD *
FROM File1.qvd (qvd);
Table2:
LOAD *,
If(Exists(FieldInTable1, FieldInTable2), 1, 0) AS ExistsInTable1
FROM File2.qvd (qvd)
The latter using a set analysis based on a new field created in the load script
Table1:
LOAD *,
1 AS Source
FROM File1.qvd (qvd);
Table2:
LOAD *,
2 AS Source
FROM File2.qvd (qvd);
The expression in a chart:
Count({< Source = {1, 2} >} NameOfField)
Hope that gives you the idea.
Miguel
Thanks alfasierra For help And Special Thanks to Miguel, It works !!