Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a sales table with all field like company , invoice date , stock code , selling price , costing price , date of transaction and Source_sales field for group by country.
I also have a inventory table . Which also have stock code field , Qty on hand , Amount on hand and Source_stock field for group by country.
I have create a link key between both table , using stock code and Source_sales for sales table.
I also create a link key for Inventory table , using stock code and Source_stock , both link field are same.
Now the above is running fine. But the issue is Source_sales and Source_stock this field name are different.
I like to make the above field name dames.
Can some one advise me how ?
Paul
can you please share your app ?
Hi Paul,
Qualify and Unqualify statements will be helpful to keep your field name same or different based on the requirement.
HTH
Sreeni
Hi Paul,
While loading just rename Source_sales and Source_stock as Source, so that this fields will be joined.
Regards,
Jagan.
Hi Jagan
I will try your suggestion.
Paul
Sent from my iPhone
Hi Jagan
I change the below script :-
'TDSS' as SOURCE_STK,
To below :-
'TDSS' as SOURCE,
when i reload the script , it hung :-
Hi Avinash
My issue is , for below field name :-
'TDSS' as SOURCE_STK,
I wish i can change to :-
'TDSS' as SOURCE,
Paul