But these fields are creating a syn Table, what is the solution can I use AS to rename them with SQL Select or Load Statemant, can you please rename them for me so i could learn how to do it. any help will be highly appreciated,
Load "CHANNEL_ID" as [COST CHANNEL_ID], "PROD_ID" as [COST PROD_ID], "PROMO_ID" as [COST PROMO_ID], "TIME_ID" as [COST TIME_ID], "UNIT_COST" as [COST UNIT_COST], "UNIT_PRICE" as [COST UNIT_PRICE];
SQL SELECT
"CHANNEL_ID",
"PROD_ID",
"PROMO_ID",
"TIME_ID",
"UNIT_COST",
"UNIT_PRICE"
FROM SH.COSTS;
Please note a couple of things:
1) Oracle defaults to returning all column names in UPPERCASE, so make sure you type them in UPPERCASE in your load script. You can then rename them to lowercase- for example, "PROD_ID" as [Cost_Prod_ID] will work in the Load script.
2) Square brackets are not necessary unless your names contain spaces or other problematic characters, but it's a good habit to use them anyway, so I've included them in my example. "PROD_ID" as COST PROD_ID, would have worked just fine if you'd prefer not to use brackets.
Oracle does not use & for concatenation, it uses || (two pipes).
You should write your queries in an Oracle-friendly environment - for example, PL/SQL Developer - and then copy them to QlikView once you're sure they work. The issues you're asking about have nothing to do with QlikView, they're strictly Oracle SQL. QlikView's editor is not a friendly place to write SQL, as there's no parsing, auto-complete, or any of the other options you'd enjoy in an SQL editor.
