topic Re: Load extra one collumn in preceeding load - Preceeding load problem in QlikView

Load extra one collumn in preceeding load - Preceeding load problem

ananyaghosh — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have using the following code and 'ChnlCode' column is loaded along with two other columns and I only expect it will only contain two column: [%Territory Key],Flag

[BC]:
Load
[%Territory Key],
if (ChnlCode=6,'DCIO',if(Match(ChnlCode,'1', '11', '12', '2'),'BC')) as Flag;

Load [%Territory Key],
[Channel Code] as ChnlCode,
[Wholesaler Full Name]
Resident [Dim Territory];

left Join
Load [Channel Code] as ChnlCode
Resident [Dim Channel]
where match([Channel Code],'1', '11', '12', '2','6');

Please suggest what is wrong here?

Re: Load extra one collumn in preceeding load

Anil_Babu_Samineni — Wed, 10 May 2017 11:09:13 GMT

May be use this?

[BC]:
Load
[%Territory Key],
if (ChnlCode=6,'DCIO',if(Match(ChnlCode,'1', '11', '12', '2'),'BC')) as Flag;

Load [%Territory Key],
[Channel Code] as ChnlCode,
[Wholesaler Full Name]
Resident [Dim Territory];

[Dim]:

Load [Channel Code] as ChnlCode

Resident [Dim Channel]

left Join ([BC])
Load ChnlCode
Resident [Dim]
where match(ChnlCode,'1', '11', '12', '2','6');

Re: Load extra one collumn in preceeding load - Preceeding load problem

vinieme12 — Wed, 10 May 2017 11:12:28 GMT

can you explain clearly what is your current output and the expected output?

Are you getting any error messages?

Re: Load extra one collumn in preceeding load - Preceeding load problem

sunny_talwar — Wed, 10 May 2017 11:14:38 GMT

Where are you Left Joining this into? BC? But BC doesn't even have ChnlCode anymore?

left Join

Load [Channel Code] as ChnlCode

Resident [Dim Channel]

where match([Channel Code],'1', '11', '12', '2','6');

Re: Load extra one collumn in preceeding load - Preceeding load problem

vinieme12 — Wed, 10 May 2017 11:16:59 GMT

You are basically creating a Cartesian Join

BC Left JOIN table2

[%Territory Key] ChnlCode

Flag

So each row of BC will be joined with each row of table2

[BC]:
Load
[%Territory Key],
if (ChnlCode=6,'DCIO',if(Match(ChnlCode,'1', '11', '12', '2'),'BC')) as Flag;

Load [%Territory Key],
[Channel Code] as ChnlCode,
[Wholesaler Full Name]
Resident [Dim Territory];

left Join
Load [Channel Code] as ChnlCode
Resident [Dim Channel]
where match([Channel Code],'1', '11', '12', '2','6');

Re: Load extra one collumn in preceeding load - Preceeding load problem

ananyaghosh — Wed, 10 May 2017 11:34:55 GMT

hi,

Basically I want to join 'Dim Territory' table with [Dim Channel] , based on [Channel Code] column and want to load

[%Territory Key],Flag columns only for whole set of data.

So I am using:

[BC]:
Load
[%Territory Key],
if([Channel Code]=6,'DCIO',if(Match([Channel Code],'1', '11', '12', '2'),'BC')) as Flag;
Load [%Territory Key],
[Channel Code],
[Wholesaler Full Name]
Resident [Dim Territory];

left Join
Load
if([Channel Code]=6,'DCIO',if(Match([Channel Code],'1', '11', '12', '2'),'BC')) as Flag;
Load [Channel Code]
Resident [Dim Channel];

code. But when I choose [Channel Code] as filter from the drop down, wring result is showing.

Re: Load extra one collumn in preceeding load - Preceeding load problem

vinieme12 — Wed, 10 May 2017 11:36:44 GMT

sorry buddy you post still doesn't give any clarity on what you are trying to do with the JOIN

Can you post a sample

Preparing examples for Upload - Reduction and Data Scrambling

Qlik Community Tip: How to Get Answers to Your Post

Re: Load extra one collumn in preceeding load - Preceeding load problem

sunny_talwar — Wed, 10 May 2017 11:43:28 GMT

100% agree with Vineeth... no idea what you are doing and what is going wrong when you select Channel Code

Re: Load extra one collumn in preceeding load - Preceeding load problem

ananyaghosh — Wed, 10 May 2017 12:36:54 GMT

Hi,

I am using the following code to join two tables: 'Dim Territory' table with [Dim Channel] , based on [Channel Code] column and want to load only [%Territory Key] and FLAG column in the BC table, as I only use two columns in the preceding load. But when I load the data it loads three columns: [%Territory Key] , FLAG and [Channel Code] in the BC table.

So how can I overcome this situation? means how to only load two column?

[BC]:
Load
[%Territory Key],
if([Channel Code]=6,'DCIO',if(Match([Channel Code],'1', '11', '12', '2'),'BC')) as Flag;
Load
[Channel Code],
[Wholesaler Full Name]
Resident [Dim Territory];

left Join
Load [Channel Code]
Resident [Dim Channel];

Re: Load extra one collumn in preceeding load - Preceeding load problem

vinieme12 — Wed, 10 May 2017 13:12:15 GMT

'Dim Territory' table with [Dim Channel] , based on [Channel Code]

Assuming you only want to keep those [%Territory Key] which exist in field [Channel Code]

You should be using RIGHT KEEP instead of Left JOIN!!

try below

[BC]:
Load
[%Territory Key],
if([Channel Code]=6,'DCIO',if(Match([Channel Code],'1', '11', '12', '2'),'BC')) as Flag;
Load
[Channel Code],
[Wholesaler Full Name]
Resident [Dim Territory];

RIGHT KEEP

temp:
Load [Channel Code] as [%Territory Key],
Resident [Dim Channel];

Drop table temp;