Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear folks,
i have two tables. in the first table i have 12 columns in the second table i have 6 columns. in the both the table 3 commons GPO Material Material Group are common fields
when i use concateante (Tab1) to join the two tables there is no error showing . but the data is not loaded for second table please guide me where i am doing the mistake.shall i use any condition for that.
Hi,
Try like this
DATA:
LOAD GPO,
[GPO number],
Customer,
[Customer Num],
Tier,
[Material Group],
Material,
Volume,
[Projected Volume],
[WAC Sales],
[Contract Sales],
[Admin Fee],
[Standard Rebates],
[Growth Rebates],
[Net Sales],
Cost,
[Sales Incentive],
[GM $],
Month,
Quarter,
Year
FROM
[F1.xlsx]
(ooxml, embedded labels, table is Data);
//Inner Join IntervalMatch (GPO,Material,[Material Group])
LEFT join LOAD GPO,
Contract,
Material,
Name,
[Material Group],
[Contract Price],
[Tier 1],
[Tier 2],
[Tier 3]
FROM
[F1.xlsx]
(ooxml, embedded labels, table is [TIER INFO]);
Qlikview automatically joins the tables based on the common columns, manually check whether there are any matching records in both the tables. Note: Qlikview is Case sensitive so the data in the fields should be in the same case.
Regards,
Jagan.
Regards,
Jagan.
Hi
Can you post the script?
DATA:
LOAD GPO,
[GPO number],
Customer,
[Customer Num],
Tier,
[Material Group],
Material,
Volume,
[Projected Volume],
[WAC Sales],
[Contract Sales],
[Admin Fee],
[Standard Rebates],
[Growth Rebates],
[Net Sales],
Cost,
[Sales Incentive],
[GM $],
Month,
Quarter,
Year
FROM
[F1.xlsx]
(ooxml, embedded labels, table is Data);
//Inner Join IntervalMatch (GPO,Material,[Material Group])
join LOAD GPO,
Contract,
Material,
Name,
[Material Group],
[Contract Price],
[Tier 1],
[Tier 2],
[Tier 3]
FROM
[F1.xlsx]
(ooxml, embedded labels, table is [TIER INFO]);
Hi
Form the key by using with three common field and joining with that field.
Hi,
Try like this
DATA:
LOAD GPO,
[GPO number],
Customer,
[Customer Num],
Tier,
[Material Group],
Material,
Volume,
[Projected Volume],
[WAC Sales],
[Contract Sales],
[Admin Fee],
[Standard Rebates],
[Growth Rebates],
[Net Sales],
Cost,
[Sales Incentive],
[GM $],
Month,
Quarter,
Year
FROM
[F1.xlsx]
(ooxml, embedded labels, table is Data);
//Inner Join IntervalMatch (GPO,Material,[Material Group])
LEFT join LOAD GPO,
Contract,
Material,
Name,
[Material Group],
[Contract Price],
[Tier 1],
[Tier 2],
[Tier 3]
FROM
[F1.xlsx]
(ooxml, embedded labels, table is [TIER INFO]);
Qlikview automatically joins the tables based on the common columns, manually check whether there are any matching records in both the tables. Note: Qlikview is Case sensitive so the data in the fields should be in the same case.
Regards,
Jagan.
Regards,
Jagan.
Try to load with the composite keys or otherwise use simple join between them
DATA:
LOAD
GPO&'_'&Material&'_'&[Material Group] as Key,
//GPO,
[GPO number],
Customer,
[Customer Num],
Tier,
//[Material Group],
//Material,
Volume,
[Projected Volume],
[WAC Sales],
[Contract Sales],
[Admin Fee],
[Standard Rebates],
[Growth Rebates],
[Net Sales],
Cost,
[Sales Incentive],
[GM $],
Month,
Quarter,
Year
FROM
[F1.xlsx]
(ooxml, embedded labels, table is Data);
join
LOAD
GPO&'_'&Material&'_'&[Material Group] as Key
//GPO, //rename this fields
Contract,
//Material, //rename this fields
Name,
//[Material Group], //rename this fields
[Contract Price],
[Tier 1],
[Tier 2],
[Tier 3]
FROM
[F1.xlsx]