Change HIstory

[dseelam]

Hello all,

I have excel files reloading every day for past 3 days from oracle to my dashboard with fields specifically customer and order type, now there is a change in oracles amazon.com customer belong to new order type ecom earlier it was dotcom from now I am capturing new change how can I change history for past 365 day files?

guys please tell be best approach

thanks

D

Message was edited by: Dinesh Reddy Seelam

[vishsaggi]

Can you elaborate a little please. Is there a field that stores ecom and dotcom? What format did you store your excel files? I mean QVD or into the database or directly into your dashboard. Why cant you replace ecom with dotcom in the QV script like

If(Type = 'ecom', 'dotcom') as NewType

I am not sure about your exact data structure or model. Need more info.

[dseelam]

Vish,

Order type is the field name and earlier there is type called dot com recently it was changed to ecom, am storing in form of QVD, I can replace those but i need change for only history

Thanks,

D

[vishsaggi]

How do you identify historical data with New data? May be flag the historical data and use that flag to change the Type.

May be this, i am not sure how exactly you data looks, can you share a sample and a snapshot of your expected output screenshot if possible.

Like

LOAD *,

          IF(HistoryFlag = 1, 'dotcom', OrderType) AS NewOrderType;

LOAD

If(OrderType = 'ecom', 1, 0) AS HistoryFlag

.....

;

[dseelam]

Vish,

Attached a sample QVW

earlier amazon.com customer used to be us standard sales order now they changed it to us eCom standard in oracle recently I would like to see amazon.com to be us eCom standard order type

thanks,

D

[vishsaggi]

I can see the qvw file, but not sure what you are trying to do here? Can you elaborate plz, in your qvw file how can you What is that you want to see?

[dseelam]

If you see in QVW AMAZON.COM belong to 4 order types I want it to be only US ecom Standard going further

[vishsaggi]

Try this?

TABLE1:

LOAD MASTER_CUST_NAME,

     IF(MASTER_CUST_NAME = 'AMAZON.COM', 'US eCom Standard', ORDER_TYPE) AS ORDER_TYPE

FROM

YourExcelPathHere

(biff, embedded labels, table is Sheet1$);