Join tables not showing any data

[D19PAL]

Hi Guys

Sorry for all the questions.

I've got the below script which was working perfectly, but all of a sudden, I can see the fields but no data, simple 1 to 1 join.

FactTemp:

NoConcatenate

            id   

FROM [**********.qvd] (qvd)   ;

LIB CONNECT TO '****************************)';

left Join (FactTemp)

SQL

select

            id,

    sales,

    currency

from

            Sales;

LIB CONNECT TO '*********)';

left join (FactTemp)

SQL

select

            id,

    targets

from

            targets;

    exit Script

I can see all the fields, but no data in sales, currency or targets.  I have checked if there's data and a match in them.

Thanks

[joaopaulo_delco]

Hi @D19PAL !

     This usually happens when the type of fields is different. 

Maybe in your qvd the id field is a number and sql source is a text.

I suggest put a Load  statement in every Sql query like "Load Text(id) ..." and also in your qvd like below:

FactTemp:
NoConcatenate
   Text(id) as id   
FROM [**********.qvd] (qvd);

LIB CONNECT TO '****************************)';

left Join (FactTemp)
Load 
    Text(id) as id,
    sales,
    currency;
SQL
select
   id,
   sales,
   currency
from Sales;

LIB CONNECT TO '*********)';
left join (FactTemp)
Load 
    Text(id) as id,
    targets
SQL
select
   id,
   targets
from
 targets;
 
exit Script;