table not found

[gauthamchilled]

I am getting the table not found error...in the attached qvw

can anyone help?

[#2 · Accepted solution]

Hi

you mast insert NoConcatenate like this

NoConcatenate
RatesUSD:
Load
Currency,
DATE,
Rates
Resident Tab1;

DROP Table Tab1;

[sasiparupudi1]

Try like this

Data:

Load * inline

[Sales,DATE

5000,10/11/2014

3000,11/11/2014

];

Tab1:

Load * inline

[

Currency,DATE,Rates

INR,10/11/2014,2.0123

MYR,11/11/2014,2.0113

];

NoConcatenate

RatesUSD:

Load

Currency,

DATE,

Rates

Resident Tab1;

DROP Table Tab1;

New:

Load

Sales AS OriginalData,

DATE AS ExchangeRateDate,

'INR' as OriginalCurrency

Resident Data;

Left Join (New)

Load

Currency as OriginalCurrency,

Rates as MYR

Resident RatesUSD;