Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I Have 4 Table
The column name of all the excel sheets are as follow with table name .Can someone tell me during modelling what technique do i need to use , do need to go for Concatenate , join ?
Help will be really appreciated
Factory:
Product_ID
Product
Price
Vat
Location
Department:
Product_ID
Product
Price
Vat
Department
LOB
Billing:
Department
Product_ID
Product
Price
DIm
Land
Stores:
Department
Store_ID
Product
Price
Location
you can use join instead concatenate
Won't be 100% certain before seeing the actual data, but I think you need to use a Join here.
Rename Price and Vat fields in all the tables (so each table have a different field name for Price and VAT, then load as is, everithing will be associated ...
let me know
you can use join instead concatenate
In "Stores" table, you have the description of product (Product), but not the ID (Product_ID) why?
Why you hold product name (Product) in every table?
You have 3 problems (!!):
1) Duplication of field names (like "Price")
2) Duplication of field (like "Product")
3) You have to choose the position of product_id (to get the product description, that I hold in just one table)
This is my answer:
BUT:
You heve to create some AutoNumberHash128 key linking Department and Product_ID
then you have to choose which table must hold the product_id in order to link factory table (I choose Billing in my view but I'm not sure is the right position)...
Hi,
Can you attach some sample data?