Where statement

Anonymous — Wed, 05 Dec 2018 21:47:09 GMT

Hey there

I'm creating a data model following a specs document that says I need to stretch a single table to a fact table with multiple dimensions. So I now I have a fact table with of course multiple dimensions, each dimension has an ID. Now I need to connect these dimensions to the fact table.

What I originally had in mind was the following:
-CREATE DIMENSIONS (With fields: Id,DimensionName)-
-CREATE FACT TABLE (With every field from the single table; Fields: FactName, Dimension)-
-
TempTable:
LOAD
Id as DimensionId
Resident Dimension;
- (create a temporary table to store the ID of the dimension)
Concatenate Load * Resident FactTable WHERE Dimension = DimensionName-(Concatenate Temptable with FactTable)

To explain further what I'm trying to do is: to add the ID of the dimension to the FactTable with a where clause that compares the non-id-field of the Dimension with the field in the FactTable and then replace that field in the FactTable with the corresponding ID that references to the ID in the Dimension table.

When I try to load the data the output shows: "Table: 'FactTable' Not found: Concatenate Load * Resident FactTable WHERE Dimension = DimensionName"

Does anyone know how I can solve this problem better?

Re: Where statement

lblumenfeld — Thu, 06 Dec 2018 05:38:53 GMT

Can you post your entire script? You might need to do a noconcatenate, but it's not clear without all the information.

topic Re: Where statement in Connectivity & Data Prep

Where statement

Re: Where statement