Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Add specific value to columns resulting in doubling number of rows

Hi guys ... I need some help for the following problem.

In my loading Script I have two tables:

Table1: some Markets with some Articles

MarketArticle
1c
1a
1b
2a

Table2: All Deliverer for each combination of Market and Article

MarketArticleDeliverer
1a500
1b500
1c100
2a100

Now I want to join both tables.

Looks like this:

MarketArticleDeliverer
1c100
1a500
1b500
2a100

Until here I have no problems.

Now I want to add the Value '0' to "Deliverer" for each row of the third table (this will double the number of rows).

Result should look like this table:

Market
ArticleDeliverer
1c0
1c100
1a0
1a500
1b0
1b500
2a0
2a100

Anybody got an idea how I can create this last table?

Thanks for your help!

1 Solution

Accepted Solutions
flipside
Valued Contributor II

Re: Add specific value to columns resulting in doubling number of rows

Hi mathiass,

If I understood right, just use ...

Markets:

Load Market, Article, 0 as Deliverer

resident Markets;

flipside

2 Replies
flipside
Valued Contributor II

Re: Add specific value to columns resulting in doubling number of rows

Hi mathiass,

If I understood right, just use ...

Markets:

Load Market, Article, 0 as Deliverer

resident Markets;

flipside

Not applicable

Re: Add specific value to columns resulting in doubling number of rows

Thanks a lot  ... works fine