unmapped columns

[#1]

Hi ,

I have a scenario as below

map:

Mapping Load.

X ,Y

...

SQL select * from ....table1

Load

X

y

ApplyMap('X .......) .

SQL ...table 2

now my issue is table 1 other than X and Y columns  I have 4-5 additional columns which is very much required.

As a 3rd step ..I created a load statement again to table 1 to have the columns

Load.

X.

y,

Z,

DATE,

DATE2.

FROM tABLE1.

Mapping load works very good. But my additional columns that is Z , date 1 ,date 2 if I include them in the report. 2 problems occurs

1. if I include in the expression I get no data for these 3 columns.

2. if I include these 3 columns in the dimension I get data duplicated too much..

[#2]

hi genarro.

But my date 1 and X and Y are in table 1 ..how could give as SQL from table 1 here

Table1:

Load.

X.

Y,

ApplyMap(X,....) as mapping,

Z,

DATE,

DATE2.

From SQL select * from ....table1

this above load is from Table 2

[#3]

sorry genarro,

Z, Date1 and Date 2 are from Table 1 and X and Y  only in Table 2

[#4]

Hi Sunny,

I hope it is little clear now .it was typo mistake

now on my report.. i have all the columns of map2.now i need columns of map 1 also..so i created another load statement

Products:
//MAPPING LOAD ( It is normal LOAD.. it is a typo mistake)
prodid,         ,
customerId ,
        Product serial no,
        description,
name
        status
     
    ;
   
SQL SELECT *
FROM ods.products

[#5]

Okay, but what is the relationship between Table 1 and Table 2?
The X and Y are present only in Table1?
If you have a way to relate you can upload them to join Left partento from that complete and adding columns mapped into left.

I thought I had understood that the Table1 and Table2 were the same except that the first is a presnete applyMap, but I was wrong

[#6]

Gennaro,

yes relationship between Table 1 and Table 2 is only X. and Y .. and X is the common id we can say...

now when I tried to load the table 1 to get the other columns like Z, Date1 and Date 2 using below

Load

X,

Y,

Z, Date1 and Date 2

from ......Table 1;

#After this when I use Z, Date1 and Date 2 on the report as a dimension or an expression..

1. if I include in the expression I get no data for these 3 columns.

2. if I include these 3 columns in the dimension I get data duplicated too much

[#7]

Can you post the portion of scritpt load for mapping table table1 and table2 ?

[#8]

Sorry I see now the the code was just posted

[#9]

Hi benny,

try whit a script like this:

map1:

MAPPING LOAD Distinct

prodid,

customerId

From

SQL SELECT prodid,

customerId FROM ods.products;

map2:

LOAD

CustomerId,

ApplyMap ('map1',customerId ) as CustId,

name,

    Address,

    street,

    bus,

    country

FROM

SQL SELECT

*

FROM ods.customer;

Products:

LOAD

prodid,

customerId,

[Product serial no],

description,

name,

status

FROM

SQL SELECT *

FROM ods.products;

Left Join(Products)

LOAD

CustomerId,

CustId,

name as nameCustomer, //given that field name exists in the product table here add an alias

Address,

street,

bus,

country

RESIDENT map2;

Drop table map1;

Drop table map2;

Regards

Gennaro

[#10]

Hi gennaro

iam facing the same issue. if you put thise under expression its blank ..in dimension it is duplicating 3-4 times